Count if cells have multiple data

T

telewats

Hello,

Is there a way to count cells that contain multiple data? For example,
I want to count the cells that contain ">5 days:001", ">5 days:002",
">5 days:003", etc. The cells contain more data than I've listed,
however this is the data I need to pull. I've tried the COUNTIF
function, and it seems to be working if I only include one or two
criteria, but I have six criteria I need to count.

Thanks!
 
R

Ron Rosenfeld

Hello,

Is there a way to count cells that contain multiple data? For example,
I want to count the cells that contain ">5 days:001", ">5 days:002",
">5 days:003", etc. The cells contain more data than I've listed,
however this is the data I need to pull. I've tried the COUNTIF
function, and it seems to be working if I only include one or two
criteria, but I have six criteria I need to count.

Thanks!
Click to expand...

=COUNTIF(rng,CRITERIA_1) + COUNTIF(rng,CRITERIA_2) + COUNTIF(...



--ron
 
B

Bill Kuunders

what about =countif(B1:b10,A1)+countif(B1:B10,A2)+countif(B1:B10,A3)+
etc........

A1 ,A2,....A6 hold your six criteria
 
Top