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!