dgd1212
asked on
Change a formula to count only non-hidden cells
The formula below counts both visible and non-visible cells:
SUMPRODUCT(--(X11:X2011>=1 ), --(X11:X2011<=(W11:W2011-1 )))
Need this to count only visible cells.
Thanks in advance.
SUMPRODUCT(--(X11:X2011>=1
Need this to count only visible cells.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER