I need a formula to count visible "o" in columns and to skip hidden ones...
For rows like below it works perfectly:
However for columns it counts also hidden "o"
Is there a way to fix it?
For rows like below it works perfectly:
Excel Formula:
=SUMPRODUCT((BT2:BT596="o")*SUBTOTAL(103;OFFSET(BT2;ROW(BT2:BT596)-ROW(BT2);0)))
However for columns it counts also hidden "o"
Excel Formula:
=SUMPRODUCT((BO2:OZ2="o")*SUBTOTAL(103;OFFSET(BO2;0;COLUMN(BO2:OZ2)-COLUMN(BO2);)))
Is there a way to fix it?
Last edited by a moderator: