Archive of Mr Excel Message Board

I am using autofilter to filter out a column of dollar amounts based on certain criteria. I also have a cell that sums the column. When I filter out certain rows in the column, they are still included in the column total in my other cell's formula. Is there any way that I can sum only the rows in the column that have not been filtered out with autofilter?

Thanks in advance,
Kevin