Forum Discussion
TO COUNT A CELL WITHOUTH USING COUNTIF
So i have an issue where i have been told to count the number of cell based on a certain criteria in this case i have to calculate the number of people working in sales dept i have two columns N...
HansVogelaar Sorry but your formula isint yielding the correct answer 😞
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Thanks! This is what I see when I open the workbook:
The formula returns 2. Isn't that what you wanted?
- I have figured it out thanx a lot for all your inputs tho