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 😞
This =SUM(IF(B2:B6="Sales",1,0)) should give you correct result. Check you data either have leading or trailing space. Also this should work =SUM(--(B2:B6="Sales")).