Not able to count character string in a particular column using CountIF in LibreOffic Calc

view full story

http://askubuntu.com – I have sheet that looks like this Column A Column B Column C Column D Emp ID Location Name Function EHGIK Gurgaon Rahul Sales EHGHH Noida Jeevan Sales EHJHL Gurgaon Prakash Marketing LKHRE Delhi Sundar IT I am trying to calculate the no. of users that belong to location "Gurgaon" using countif. Have tried using countif cell range that include all cells OR only location column cells and criteria as "Gurgaon" but the formula doesn't return the count. The same formula however works (HowTos)