COUNTIFS and range

I have a column in which I need to count how many times values from other columns range.

I do it in the following way, =" Found: "&COUNTIFS(A1:A114,"="&C2) and it works.

But as soon as I set the range, =" Found: "&COUNTIFS(A1:A114,"="&C2:C3) I get an error.

Please tell me what I’m doing wrong, and how to solve it. Thank you.


may be you want to use:

="Found :" & SUMPRODUCT(COUNTIFS(A$1:A$114;"="&C2:C3))