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?