Hello,

I have a spreadsheet that I plan to use the AutoFilter sorts on. I want to have two totals at the top, one which totals everything in each one of the columns, regardless of sort status and another which only totals the values you see when the sort is being used. I have figured out how to use the Subtotal(9,...) to sum everything I have, but I am wondering if it is possible to do something similar with the CountA function so it counts the number of rows present after using the sort. Any help is greatly appreciated!

Thanks,
Bonni