Excel COUNTIF Function - Help needed

[Caz59]

Ok, I have a row with say
A1 = Pears
B1 = Oranges
C1 = Pears
D1 = Oranges

I want to count how many times it says "Pears" or "Apples", simple me thinks.

So, I'm in Cell E1, the HELP function says: =COUNTIF(A11,"Pears"), BUT it doesn't work, what on earth am I doing wrong?

HELP!
Caz

 

[Nifrabar]

Hi!
=CountIf(A11,"Pears")
should be
=CountIf(A11;"Pears")
(Semicolumn iso column.
That works for me.
-Bart

 

[Caz59]

Thanks!

 

[HarleyQuinn]

Might be worth stating what version of excel this works for (as for example in 2002 SP3 which I'm running), as the original posters formula would work whereas the posted solution does not.

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[Nifrabar]

Harley,

Excel 2002 SP3 running on XP.

KR
-Bart

 

[AnotherHiggins]

Use of comma vs semicolon is a regional thing.

In the US we use commas as separators in formulas.

Much of Europe use semicolons.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.