MrExcel Publishing
Your One Stop for Excel Tips & Solutions

autofilter question


Posted by Kevin on November 02, 2001 5:48 AM

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


Posted by Mark W. on November 02, 2001 7:16 AM

Use the SUBTOTAL worksheet function.