sum on several conditions

[AGA]

Hi,
I need a formula that would sum the numbers if firm_id, date, type and man_id are the same.

I need the sum to appear on the last record of the same firm_id/date/type and man_id.
Please find an example attached. The columns marked in red colour represent the ones that I need to be generated by a formula.

Thanks,

[Fotis1991]

Hi

Try.

=SUMPRODUCT((($A$2:$A$13=A2)*($B$2:$B$13=B2)*($C$2:$C$13=C2)*($D$2:$D$13=D2)*($E$2:$E$13)))

[DGagnon]

i dont understand the requirements, for example cell G9 is totaling E9+E8+E7, but they all have different IDs and Dates.

can you please clarify the requirement?

[AGA]

Hi

Try.

=SUMPRODUCT((($A$2:$A$13=A2)*($B$2:$B$13=B2)*($C$2:$C$13=C2)*($D$2:$D$13=D2)*($E$2:$E$13)))

Hi, Thanks for this, but it does not give me what I need.
I need two columns to be populated with numbers (F,G on the example spread sheet).
Also I would like the rows, that are not the last records of a patricular man_id/date/firm/type to be empty or equal zero.


Thanks,

[AGA]

i dont understand the requirements, for example cell G9 is totaling E9+E8+E7, but they all have different IDs and Dates.

can you please clarify the requirement?

I apologise for this.
I uploaded a file with corrections.
Could you have another look?
Thank you.

[DGagnon]

Thank you for the update,

In column F use this

=IF(COUNTIFS(A$1:A2,A2,B$1:B2,B2,C$1:C2,C2,D$1:D2,D2)=COUNTIFS(A:A,A2,B:B,B2,C:C,C2,D:D,D2),1,0)

in column G use this

=IF(F2=1,SUMIFS(E$1:E2,A$1:A2,A2,B$1:B2,B2,C$1:C2,C2,D$1:D2,D2),"")

see attached file for details.