COUNTIFS and range

English
, , ,
#1

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.

image description
image description794×517 47.7 KB

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.

#2

Hello,

may be you want to use:

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

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.