Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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 fine when counting names using "Rahul" as criteria returns '1" and the same with any function name such "Sales". But the count does not return any value other than '0" whenever I select any of the location names such as Gurgaon or Noida or EMP ID using "" double quotes. Can't understand why?

share|improve this question
Well, Please post your question to ask.libreoffice forum –  Prashere Dec 31 '12 at 13:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.