count if

  • Thread starter Help with count if
  • Start date
H

Help with count if

I need to count cells -than content text not numbers- with a defined
condition but the cells are not follow (not a range or cells). What
function/s can I use?
 
J

JulieD

you can use the countif function
for example if you have
.........A..............B
1.....cat..........dog
2....mouse.....cat
3.....cat........cat

and want to count all the cats in A1:B3
the formula would be
=COUNTIF(A1:B3,"cat")
 
T

thanks

THANKS FOR THE ANSWER!
IT TOTALLY WORKED!!

JulieD said:
you can use the countif function
for example if you have
.........A..............B
1.....cat..........dog
2....mouse.....cat
3.....cat........cat

and want to count all the cats in A1:B3
the formula would be
=COUNTIF(A1:B3,"cat")

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
Click to expand...
 
B

bj

It depends on how many cells you want to count, If is less than 30 use
=count(a1,a3,a5,c4,t8,...)
if it is more than 30
select the cells using th control key
go to <insert><Name><define> and give a unique name to the group (for
example "rover"
then use
=count(rover)
I do not know how many cells can be named in a group, you may have to use
several names of groups to get up to your total requirements
=count(rover,spot,reX)
 
Top