Filters & Sum

[PCOR]

Hi All
I have a spreadsheet that contains 10 cols and about 20 rows

I have set the filter for Col b to show only entries that show "orange"
Col d contains a dollar value.
How do I get a SUM of col D after the filter has been set to "ORANGE:
All works ok when the filter is not set and my total for col D is correct
Appreciate any help
Ian

 

[Tom Ogilvy]

=subtotal(9,D221)

subtotal respects the filter - only operates on the non-hidden rows. the
first argument says what function to perform. 9 is sum, 2 is count as
examples.

 

[PCOR]

So easy...when you know how.
Many thanks
Ian

=subtotal(9,D221)

subtotal respects the filter - only operates on the non-hidden rows. the
first argument says what function to perform. 9 is sum, 2 is count as
examples.