COUNTIFS across a column range

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

How about

Formula:

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

Gosh is it that simple. I was so close.

Perfect

Thanks so much

HAPPY CHRISTMAS

Glad to help & thanks for the feedback.