if, countif, vlookup

  • Thread starter Thread starter RichardO
  • Start date Start date
R

RichardO

Hello all:

I have the following formula:

=IF(COUNTIF(Richardo,$A13)>0,COUNTIF(Richardo,$A13),"")

and it works okay, by counting the items in A13 in the Range richardo.


But I want to add to the formula such that, if it doesn't find the ite
A13 in the range RichardO, it should check the range Orlando. How do
do this? Thanks a lot.


RichardO
 
What do you mean "check" the range? You can try just replacing the "" with
COUNTIF(Orlando, $A13). If by "check" you mean do the same thing you did for
Richardo, then just add another IF statement like the one you wrote below,
except referencing Orlando.
 
Back
Top