Filters & Sum

P

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
 
T

Tom Ogilvy

=subtotal(9,D2:D21)

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.
 
P

PCOR

So easy...when you know how.
Many thanks
Ian
Tom Ogilvy said:
=subtotal(9,D2:D21)

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.
Click to expand...
 
Top