Code:=COUNTIFS(AL3:AL40[B][COLOR=#ff0000];[/COLOR][/B]">=4.5"[B][COLOR=#ff0000];[/COLOR][/B]AL3:AL40[B][COLOR=#ff0000];[/COLOR][/B]"<=5")
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.
Do both of you computers have the same region settings?
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?
Many thanks (Y)