COUNTIF???

Posted by Rocco on July 06, 2001 7:27 PM

=COUNTIF(C:C,"AB")allows me to find everything in column C that has an AB. I would also like it to find FG. When I try and place it in the above formula, I receive an error message. Can anyone explain?

Thanks

Rocco

Posted by Scott S on July 06, 2001 8:09 PM

If you replace the AB with the FG (don't forget the ""), it should work. If you would like it to count both AB and FG, then you could write it like this:

=(COUNTIF(C:C,"AB")+=COUNTIF(C:C,"FG"))

Posted by Scott S on July 06, 2001 8:10 PM

OOPS

Oops, I had the "=" in there twice. It should read:

=(COUNTIF(C:C,"AB")+COUNTIF(C:C,"FG"))

Posted by Anthony on July 06, 2001 9:33 PM

Re: OOPS

It Worked! Thanks Scott!!

Anthony