count if

[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?

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Help with count if" <Help with count if@discussions.microsoft.com> wrote in
message news:F38031F6-C388-4555-B54C-9B074854217E@microsoft.com...
>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]

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 if@discussions.microsoft.com> wrote in
> message news:F38031F6-C388-4555-B54C-9B074854217E@microsoft.com...
> >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're welcome and thanks for the feedback


"thanks" <thanks@discussions.microsoft.com> wrote in message
news:AC35900A-76DE-4BA7-8D5D-E8BAFA00788B@microsoft.com...
> 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 if@discussions.microsoft.com> wrote
>> in
>> message news:F38031F6-C388-4555-B54C-9B074854217E@microsoft.com...
>> >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?
>>
>>
>>

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

"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?