countif help

[saybut]

Hi,

Could anyone tell me how to/if its possible to use count if but specif
several criteria for the same count?

I currently have one =countif(E:E,"DAR") I'm trying to sum up, "DAR"
"DAC", "DAO" in the same cell. I thought something lik
=countif(E:E,"DAR","DAC","DAO") but it doesnt work & I can't figure ou
what to do!

any help is greatly appreciated

 

[Ron Coderre]

Try this:

A1: =SUMPRODUCT(COUNTIF(E:E,{"DAR","DAC","DAO"}))

(Note the curly braces around the criteria array)

Does that help?

Regards,
Ro

 

[Guest]

Hi

Use three separate COUNTIFs and add them together:
=countif(E:E,"DAR") + countif(E:E,"DAO") + countif(E:E,"DAC")

Andy.

 

[saybut]

Hi Ron,

thats brilliant thanks. It works a treat. I don't know if you change
your post but it came through on email as "sumproduct" rather than jus
"sum". The both do the same though.

Thanks again.

mark

 

[Ron Coderre]

Mark

Thanks for the feedback...I'm glad that worked for you.

Yeah...I edited the post to change it from SUMPRODUCT to SUM.
I thought I could finish the edit before the forum posted up to th
newsgroups...but, evidently not.

Regards,
Ro