Forum Discussion
hsduk101
Apr 25, 2023Copper Contributor
Formula to Count only filtered columns but also doesnt count hidden cell formulas
All, I have a subtotal formula (=subtotal(3,xx:xx)) counting cells and it does a excellent job of count only filtered cells (adjusting to the filter) However if i throw in a formula to the ce...
Patrick2788
Apr 25, 2023Silver Contributor
You could use AGGREGATE to count the cells. It's capable of ignoring cells with SUBTOTAL formulas.