Autofilter with Subtotal Sumif
Hi
Small example of data
Name Amount Paid
Sheri $10.00 Yes
Sheri $15.00 No
Maureen $25.00 No
Maureen $12.00 Yes
If I AutoFilter the the list for Name "Sheri", how can I use the Subtotal
and Sumif functions together to show an answer of $15.00?
Or how can I use the Sumif or Sumproduct functions only on the visible cells?
Plus is it possible to show the filtered name "Sheri" in a seperate cell?
--
Thank you
Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro
|