I want to replace my countifs function with a sumproduct as it doesn't work when external reference is not open.
But in my range of values, but alphabets & numerals exist and when I use countifs function, the criteria considers only numerals and avoid texts. But when I use a sumproduct with criteria it considers both numerals & texts.

=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,..)