Let's say we have some data in a spreadsheet like:
A B C Price Quantity Genre 20 2500 Car 10 1000 Car 10 2500 Bike
I can filter Cars with Quantity 2500 with
FILTER(A:A;B:B=2500;C:C="Car") - easy.
But what if there is another column, for postage, like:
A B C D Price Quantity Genre Postage 20 2500 Car 0 10 1000 Car 6 10 2500 Bike 10
I want to filter to find everything who's total price (postage+price) is
20, and I have
I tried various combinations but can't seem to do it. Should I create a sum column first?