Wondering if you could help, I am automating sales stats at the moment,
and am currently using:

=COUNTIF(N1:N500,"SJP")

Which works fine, however the field I am asking it to search can be one
of two things, the "SJP" or "SJP/MBL" and I need it to check for both,
I have tried:

=COUNTIF(N1:N500,"SJP""SJP/MBL")
=COUNTIF(N1:N500,"SJP","SJP/MBL")

Which both don't work - how do I get it to do an 'or' function?

Any help would be appreciated.

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

=COUNTIF(N1:N500,"SJP")+COUNTIF(N1:N500,"SJP/MBL")

--
HTH. Best wishes Harald
Followup to newsgroup only please

"digitallifeform" <(E-Mail Removed)> skrev i
melding news:(E-Mail Removed)...
> Wondering if you could help, I am automating sales stats at the moment,
> and am currently using:
>
> =COUNTIF(N1:N500,"SJP")
>
> Which works fine, however the field I am asking it to search can be one
> of two things, the "SJP" or "SJP/MBL" and I need it to check for both,
> I have tried:
>
> =COUNTIF(N1:N500,"SJP""SJP/MBL")
> =COUNTIF(N1:N500,"SJP","SJP/MBL")
>
> Which both don't work - how do I get it to do an 'or' function?
>
> Any help would be appreciated.
>
> Thanks
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

=COUNTIF(N1:N500,"*SJP*")

aLAN bEBAN

digitallifeform wrote:
> Wondering if you could help, I am automating sales stats at the moment,
> and am currently using:
>
> =COUNTIF(N1:N500,"SJP")
>
> Which works fine, however the field I am asking it to search can be one
> of two things, the "SJP" or "SJP/MBL" and I need it to check for both,
> I have tried:
>
> =COUNTIF(N1:N500,"SJP""SJP/MBL")
> =COUNTIF(N1:N500,"SJP","SJP/MBL")
>
> Which both don't work - how do I get it to do an 'or' function?
>
> Any help would be appreciated.
>
> Thanks
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

On Fri, 17 Oct 2003 08:41:16 -0700, Alan Beban <(E-Mail Removed)>
wrote:

>=COUNTIF(N1:N500,"*SJP*")
>
>aLAN bEBAN

That works so long as if the field contains SJP, it will only contain either
SJP or SJP/MBL. However, if there are other SJP containing fields, than the
formula fails.


--ron

The OP said:

the field I am asking it to search can be one
of two things, the "SJP" or "SJP/MBL"

Alan Beban

Ron Rosenfeld wrote:
> On Fri, 17 Oct 2003 08:41:16 -0700, Alan Beban <(E-Mail Removed)>
> wrote:
>
>
>>=COUNTIF(N1:N500,"*SJP*")
>>
>>aLAN bEBAN
>
>
> That works so long as if the field contains SJP, it will only contain either
> SJP or SJP/MBL. However, if there are other SJP containing fields, than the
> formula fails.
>
>
> --ron

> >>=COUNTIF(N1:N500,"*SJP*")

> > However, if there are other SJP containing fields, than the
> > formula fails.

> The OP said:
> the field I am asking it to search can be one
> of two things, the "SJP" or "SJP/MBL"

If those two are the only values present, why COUNTIF at all ??? <bg>
Best wishes Harald

"Ours not to reason why . . . ."

Alan Beban

Harald Staff wrote:
>>>>=COUNTIF(N1:N500,"*SJP*")
>>>
>
>>>However, if there are other SJP containing fields, than the
>>>formula fails.
>>
>
>>The OP said:
>>the field I am asking it to search can be one
>>of two things, the "SJP" or "SJP/MBL"
>
>
> If those two are the only values present, why COUNTIF at all ??? <bg>
> Best wishes Harald
>
>

On Fri, 17 Oct 2003 22:14:36 -0700, Alan Beban <(E-Mail Removed)>
wrote:

>The OP said:
>
> the field I am asking it to search can be one
> of two things, the "SJP" or "SJP/MBL"


Well then, if that's all it could be:
=COUNT(N1:N500)

would be even simpler.


--ron

On Fri, 17 Oct 2003 22:14:36 -0700, Alan Beban <(E-Mail Removed)>
wrote:

>The OP said:
>
> the field I am asking it to search can be one
> of two things, the "SJP" or "SJP/MBL"

Well, simpler would be:
=COUNT(N1:N500)
=ROW(N500)
=500

<g>


--ron

"Ron Rosenfeld" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> =500
> <g>

Equal sign does what ? <bg>