error typing multiple arguments in formula bar

  • Thread starter Thread starter TEAMAUZ
  • Start date Start date
T

TEAMAUZ

simple COUNTIF and VLOOKUP functions does not work, I see a % symbol in place
of comma "," for example = COUNTIF(range%criteria) this is what apperas in my
excel workbook( using intellisence).

=COUNTIF(B2:B25%"APPLE"). even when I separate range and criteria using ","
does not work.

well normal SUM and AVERAGE functions work well as I dont have any cirteria
to give.

I really appreciate your help.

Thanks
TEAMAUZ
 
Hi,

=COUNTIF(B2:B25,"APPLE")

If this not works please let us know what results you get
 
Hi Eduardo,

I have tried typing this but even this gives me an Microsoft Error Window
saying that the formula contains errors in it. Thanks for replying me. I
appreciate your help.

Jyothi
 
Back
Top