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