dgd1212
asked on
Modifying an Excel formula to count only visible cells, not all cells
I have two formulas below that count visible and non-visible cells. Need assistance so that they only count visible cells.
Thanks
="# of Factory Issues: "&COUNTIF(AG11:AG2011,"<>" )
="Instances of 2016 Dates = "&COUNTIFS(L11:L2011,">="& $AW$2,L11: L2011,"<=" &$AW$3)
(Column AW2 and AW3 contain 1/1/16 and 12/31/16)
Thanks
="# of Factory Issues: "&COUNTIF(AG11:AG2011,"<>"
="Instances of 2016 Dates = "&COUNTIFS(L11:L2011,">="&
(Column AW2 and AW3 contain 1/1/16 and 12/31/16)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfect! Thank you for your assistance and explanation
This will count the values while you are using a filter
=SUBTOTAL(2,A2:A500)
Subtotal.xlsx