Forum Discussion
Dev_1518
Aug 17, 2022Copper Contributor
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...
Dev_1518
Aug 18, 2022Copper Contributor
@HansVogelaar
https://docs.google.com/spreadsheets/d/1PnbUq9nKv8jLcDJmqO52Be1i70WSTUWFYYoVmot1wvI/edit?usp=sharing
HansVogelaar
Aug 18, 2022MVP
Thanks! This is what I see when I open the workbook:
The formula returns 2. Isn't that what you wanted?
- Dev_1518Aug 18, 2022Copper ContributorI have figured it out thanx a lot for all your inputs tho