Forum Discussion
SUMIF Help
Hello, I was trying to use the SUMIF formula to total the number of employees that were greater/less than 6% per month per manager. Attached data as an example.
Hello CatherineMadden,
As per my understanding on your explanation, you need to use COUNTIFS function.
for Greater than 6%, in K4 put this formula:
=COUNTIFS(F$4:F$12,">0.06",$E$4:$E$12,$J4)
copy that cells and paste it on K4:M7
Less than 6%, in K11:
=COUNTIFS(F$4:F$12,"<0.06",$E$4:$E$12,$J11)
copy that cells and paste it on K11:M14
- That worked perfectly, thank you!
