need some help please, read inside, cheers!!

  • Thread starter Thread starter Wilson
  • Start date Start date
W

Wilson

Hello Peeps!

I am trying to work out a formula that can count multiple strings i.e.

=COUNTIF($E$3:$E$40,"Setup")

But not only have it count look for the word setup, have it look for
another word to i.e!!!

=COUNTIF($E$3:$E$40,"Setup", "Done")

This doesn't work but u get the jist of what i need, any help would be
much
appreciated!!me!

Thanks Alot
Kami
 
Wilson

Use separate countifs:

=COUNTIF($E$3:$E$40,"Setup") + COUNTIF($E$3:$E$40,"Done")

Andy.
 
Kami,

Try

=COUNTIF($E$3:$E$40,"Setup")+COUNTIF($E$3:$E$40,"Done")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Kami,

You can use an array of words (ie{"Setup","Done"}) which will return
an array of answers, which can then be summed.

=SUM(COUNTIF($E$3:$E$40,{"Setup","Done"}))

Dan E
 
Back
Top