Help - Countifs

[Getoarii]

Hello;

I'm using this:

=COUNTIFS(AL3:AL40;">=4.5";AL3:AL40;"<=5")

to know how many numbers are >=4.5 to <=5.

In my laptop is working, but in my computer isn't working.

 

[gaz_chops]

Are the versions of Excel the same?

 

[bbott]

=COUNTIFS(AL3:AL40[B][COLOR=#ff0000];[/COLOR][/B]">=4.5"[B][COLOR=#ff0000];[/COLOR][/B]AL3:AL40[B][COLOR=#ff0000];[/COLOR][/B]"<=5")

Do both of you computers have the same region settings?

 

[Getoarii]

Yes, Microsoft Office Professional Plus 2010.

 

[Marcelo Branco]

Maybe the Excel version on your computer uses , (comma) as argument separator.

See if this works

=COUNTIFS(AL3:AL40,">=4.5",AL3:AL40,"<=5")

Hope this helps

M.

 

[Getoarii]

Maybe the Excel version on your computer uses , (comma) as argument separator.

See if this works

=COUNTIFS(AL3:AL40,">=4.5",AL3:AL40,"<=5")

Hope this helps

M.

not working

 

[Getoarii]

Do both of you computers have the same region settings?

Many thanks (Y)

 

[Kruwler]

office 2013 uses ; instead of , to distinguish the references. 2010 Should use , instead of ;. maybe your office versions are not the same? what is the return error?

 

[Getoarii]

office 2013 uses ; instead of , to distinguish the references. 2010 Should use , instead of ;. maybe your office versions are not the same? what is the return error?

I changed region settings as bbott told me, and worked.

 

[bbott]

Many thanks (Y)

You're welcome.