Filters & Sum
 

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
--
Norton Professional 2004 says this email is clean...believe it

Filters & Sum
 

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

--
Regards,
Tom Ogilvy

"PCOR" wrote in message
. cable.rogers.com...

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
--
Norton Professional 2004 says this email is clean...believe it

Filters & Sum
 

So easy...when you know how.
Many thanks
Ian
"Tom Ogilvy" wrote in message
...
=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.

--
Regards,
Tom Ogilvy

"PCOR" wrote in message
. cable.rogers.com...

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
--
Norton Professional 2004 says this email is clean...believe it