Countif with 3 different options

's Computer Specifications

Hi everyone,

What's the syntax for adding 3 different criteria to a countif function
please? =COUNTIF(dumpers'!$E:$E,"3c-")

Dumpers can be assigned 1-10 but also 3 levels a-c within this

TIA
--
Smudge

's Computer Specifications

I am not sure what you want but mayb
=countif(dumpers!$E:$E,"3c-")+countif(dumpers!$E:$E,"3b-")+countif(dumpers!$E:$E,"3a-")

or

=sum(if(or(dumpers!$E:$E={"3c-"."3b-","3a-}),1,0))
entered as an array control-shift-enter

you cant have multiple criteria in one countif.

"Smudge" wrote:

> Hi everyone,
>
> What's the syntax for adding 3 different criteria to a countif function
> please? =COUNTIF(dumpers'!$E:$E,"3c-")
>
> Dumpers can be assigned 1-10 but also 3 levels a-c within this
>
> TIA
> --
> Smudge

's Computer Specifications

Perhaps this?

=SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"}))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Smudge" <(E-Mail Removed)> wrote in message
news:B6354841-907B-47CB-919B-(E-Mail Removed)...
> Hi everyone,
>
> What's the syntax for adding 3 different criteria to a countif function
> please? =COUNTIF(dumpers'!$E:$E,"3c-")
>
> Dumpers can be assigned 1-10 but also 3 levels a-c within this
>
> TIA
> --
> Smudge

's Computer Specifications

=COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-")
?
--
David Biddulph

"Smudge" <(E-Mail Removed)> wrote in message
news:B6354841-907B-47CB-919B-(E-Mail Removed)...
> Hi everyone,
>
> What's the syntax for adding 3 different criteria to a countif function
> please? =COUNTIF(dumpers'!$E:$E,"3c-")
>
> Dumpers can be assigned 1-10 but also 3 levels a-c within this
>
> TIA
> --
> Smudge

's Computer Specifications

Thanks Ron,

this is the one I have used even though all the other answers seem to work
Cheers
--
Smudge

"Ron Coderre" wrote:

> Perhaps this?
>
> =SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"}))
>
> Does that help?
> --------------------------
>
> Regards,
>
> Ron
> Microsoft MVP (Excel)
>
>
>
> "Smudge" <(E-Mail Removed)> wrote in message
> news:B6354841-907B-47CB-919B-(E-Mail Removed)...
> > Hi everyone,
> >
> > What's the syntax for adding 3 different criteria to a countif function
> > please? =COUNTIF(dumpers'!$E:$E,"3c-")
> >
> > Dumpers can be assigned 1-10 but also 3 levels a-c within this
> >
> > TIA
> > --
> > Smudge
>
>
>

's Computer Specifications

Thanks bj
--
Smudge

"bj" wrote:

> I am not sure what you want but maybe
> =countif(dumpers!$E:$E,"3c-")+countif(dumpers!$E:$E,"3b-")+countif(dumpers!$E:$E,"3a-")
>
> or
>
> =sum(if(or(dumpers!$E:$E={"3c-"."3b-","3a-}),1,0))
> entered as an array control-shift-enter
>
> you cant have multiple criteria in one countif.
>
>
> "Smudge" wrote:
>
> > Hi everyone,
> >
> > What's the syntax for adding 3 different criteria to a countif function
> > please? =COUNTIF(dumpers'!$E:$E,"3c-")
> >
> > Dumpers can be assigned 1-10 but also 3 levels a-c within this
> >
> > TIA
> > --
> > Smudge

's Computer Specifications

Thank you David
--
Smudge

"David Biddulph" wrote:

> =COUNTIF(dumpers!$E:$E,"3a-")+COUNTIF(dumpers!$E:$E,"3b-")+COUNTIF(dumpers!$E:$E,"3c-")
> ?
> --
> David Biddulph
>
> "Smudge" <(E-Mail Removed)> wrote in message
> news:B6354841-907B-47CB-919B-(E-Mail Removed)...
> > Hi everyone,
> >
> > What's the syntax for adding 3 different criteria to a countif function
> > please? =COUNTIF(dumpers'!$E:$E,"3c-")
> >
> > Dumpers can be assigned 1-10 but also 3 levels a-c within this
> >
> > TIA
> > --
> > Smudge
>
>
>

's Computer Specifications

I'm glad I could help........Thanks for the feedback.

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)

"Smudge" <(E-Mail Removed)> wrote in message
news:FE18F815-5950-4B04-8210-(E-Mail Removed)...
> Thanks Ron,
>
> this is the one I have used even though all the other answers seem to work
> Cheers
> --
> Smudge
>
>
> "Ron Coderre" wrote:
>
>> Perhaps this?
>>
>> =SUM(COUNTIF(dumpers'!$E:$E,{"3a-","3b-","3c-"}))
>>
>> Does that help?
>> --------------------------
>>
>> Regards,
>>
>> Ron
>> Microsoft MVP (Excel)
>>
>>
>>
>> "Smudge" <(E-Mail Removed)> wrote in message
>> news:B6354841-907B-47CB-919B-(E-Mail Removed)...
>> > Hi everyone,
>> >
>> > What's the syntax for adding 3 different criteria to a countif function
>> > please? =COUNTIF(dumpers'!$E:$E,"3c-")
>> >
>> > Dumpers can be assigned 1-10 but also 3 levels a-c within this
>> >
>> > TIA
>> > --
>> > Smudge
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2007 Indexing Options and Advanced Search options disabled	Tim	Microsoft Outlook Discussion	6	22nd Jun 2009 02:56 PM
How do I use a countif function according to two other countif fu.	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Worksheet Functions	2	20th Feb 2006 11:44 AM
COUNTIF or not to COUNTIF on a range in another sheet	=?Utf-8?B?RWxsaWU=?=	Microsoft Excel Worksheet Functions	4	15th Sep 2005 10:06 PM
Tools,Options, Email Options, AdvancedE-mail Options,	=?Utf-8?B?WWFrb3Y=?=	Microsoft Outlook	4	5th Apr 2005 09:35 AM
COUNTIF in one colum then COUNTIF in another...???	=?Utf-8?B?Sm9ubmllUA==?=	Microsoft Excel Worksheet Functions	3	22nd Feb 2005 02:55 PM