Sum on AutoFilter

[Grasshopper]

I need to do a simple AutoSum, but can't figure out how to do it while also using AutoFilter. Example: I have my AutoSum formula in B1. A2:A102 contains Months (Jan-Dec), B2:B102 contains Dollar values. I AutoFilter the Months to show only January records, but my AutoSum cell still sums all of column B even though I filtered for only January. Please Help!

[Kevin@Radstock]

Hi Grasshopper

Use the SUBTOTAL function. I personally would insert a row above your data and put column headers ie: Month & Sales. So your filters will be in these cells.

Then in B1: =SUBTOTAL(109,$B$3:$B$103)

Edit: Forgot to add that you could also use a Pivot Table. See the attached file.

Kevin

[Grasshopper]

Kevin,
Thanks so much! SUBTOTAL is exactly what I need. I'm so mad at myself for not figuring it out on my own, but I guess that's what this forum is for anyway. Thanks again!

Lynn (aka grasshopper)

[Kevin@Radstock]

Hi Lynn

No problem and thanks for the feed back.

Kevin