TO COUNT A CELL WITHOUTH USING COUNTIF

Question

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 Name and Dept

I can use =COUNTIF(RANGE,CRITERIA) to find the value but the problem is i am not allowed to use COUNTIF() and have been told to use IF function to do so . Anyone out there who can help me

oliverscheurich · Answer

Dev_1518&nbsp;=SUMPRODUCT(N($B$2:$B$6=D2))You can try&nbsp;SUMPRODUCT.&nbsp;

dev_1518 · Answer

OliverScheurich&nbsp;Guess i didnt make myself clear i have to use an IF function . so is it possible to use the sumproduct inside the IF function??

hansvogelaar · Answer

Dev_1518&nbsp;
=SUM(IF(B2:B6="Sales",1,0))
&nbsp;
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.

dev_1518 · Answer

HansVogelaar&nbsp; Sorry but your formula isint yielding the correct&nbsp; answer 😞

harun24hr · 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")).

Forum Discussion

TO COUNT A CELL WITHOUTH USING COUNTIF

Share

Resources