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
FILTER(A:A;B:B=2500;C:C="Car") - easy.
But what if there is another column, for
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 whose total price (
20, and I have
2500 of. I tried various combinations but can't seem to do it.
Should I create a sum column first?