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?

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
"Help with count if" <Help with count wrote in
message ...
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?

THANKS FOR THE ANSWER!
IT TOTALLY WORKED!!

"JulieD" wrote:

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
"Help with count if" <Help with count wrote in
message ...
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?

you're welcome and thanks for the feedback


"thanks" wrote in message
...
THANKS FOR THE ANSWER!
IT TOTALLY WORKED!!

"JulieD" wrote:

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
"Help with count if" <Help with count wrote
in
message ...
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?

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)

"Help with count if" wrote:

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?