Hi everyone

=COUNTIFS(C5:C500,"Active",M5:T500,"<>")

Doesn't work because of the M:T range involved.

Is the solution SUMPRODUCT?

=SUMPRODUCT((C5:C500="Active")*(M5:T500="<>"))

This fails.

How can I count non-blank cells across a range of columns??

THANKS