please read, formual help!!

  • 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
 
How about


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

unless they are supposed to be in the same cell

=SUMPRODUCT(--(ISNUMBER(FIND("Setup",$E$3:$E$40))),--(ISNUMBER(FIND("Done",$
E$3:$E$40))))
 
Are you having any trouble with your news reader ?

You received 3 answers an hour ago to your first post !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

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 said:
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
Click to expand...

Please do not start a second thread with the same message. Look at the
replies you received to your first post. If you need to follow these up, by
all means do so but by replying in the original thread.
 
Back
Top