Help needed to perform COUNT based on multiple criteria

[mattzz11]

I need to display the COUNTS of all 5's per sales code per department per manager in the FIVES column
as shown in the attachment.

Appreciate your help in this regard.

[Banuchander]

HI,

Please included formula to get the count of fives in fives column.

=COUNTIF(G5:L5,"5")

Please reply, if you are satisfied.

[mattzz11]

Thanks Banuchnader, how ever it won't solve my problem. Your formula gives the count of all fives, but I need the count of fives per Manager per department per Sales code...

[Fotis1991]

Hi

Do you mean?

=SUMPRODUCT(($G$5:$L$10=5)*($E$5:$E$10=E5)*($D$5:$D$10=D5))

If NO, pls tell us which are the corect results in column M?

[Banuchander]

Hi,

I think we need to given the four different formulas in M5,N5,O5 & P5 to get counts of 5's per sales code per department per manager
untitled.JPG
=COUNTIF(G5:L5,5)
=SUMIF(E:E,E5,M:M)
=SUMIF(D:D,D5,M:M)
=SUMIF(C:C,C5,M:M)

[mattzz11]

Thanks Fotis!!! the formula worked on my sample sheet and it displayed the correct values. Now when I tried the same formula on another sheet it there I can see that it worked from the fx window but it is not displaying the result on sheet in the cell, why? I really apprecaite your help!!!

[mattzz11]

Thanks Banuchander!!! I will try this too. Fotis suggested SUMPRODUCT and it is getting the result but not displaying the value on the sheet.

[Banuchander]

I attached my the excel sheet i worked for your better understand.

[mattzz11]

I attached my the excel sheet i worked for your better understand.

Hi Banuchander, I tried your appraoch but the result is not being displayed. The cell shows the formula itself, any suggestions? Thanks!

[Banuchander]

Hi mat, I think you need to press ctrl+~ which is used for show or hide the formula's

[mattzz11]

PROBLEM SOLVED. Thanks Fotis1991!!!!Thanks Banuchander!!!!

I want to mark it as Solved but I don't see Solved under 'Thread Tools'

This is a Great forum!! Keep up the good work every one!!!!!!

Have a Nice Day!!


-Mattzz

[Banuchander]

Thanks Matt to give a chance to refreshing our excel knowledge.