count if

[Guest]

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?

 

[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")

 

[Guest]

THANKS FOR THE ANSWER!
IT TOTALLY WORKED!!

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

 

[JulieD]

you're welcome and thanks for the feedback

THANKS FOR THE ANSWER!
IT TOTALLY WORKED!!

 

[Guest]

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)