Add up values reported by another sheet

[Berna11]

Good evening, I would need to change the formulas of the attached file.
As you can see, in the sheet1 I report the data from the sheet2 I would like to add the amounts in column G sheet1 if the columns A-F-H have the same data as you see in yellow and green.
Having only one row for yellow and one for green that shows the total in column G.

Thank you

For Excel 2007

[Glenn Kennedy]

I'm not at all sure if this is what you want, but...

=SUMIFS(Foglio2!J:J,Foglio2!K:K,N7,Foglio2!H:H,M7,Foglio2!C:C,L7)

[Bo_Ry]

Not sure is this right

A6, and C,E,F,H

Please Login or Register  to view this content.

G6
=SUMIFS(Foglio2!J:J,Foglio2!$C:$C,$A6,Foglio2!H:H,F6,Foglio2!K:K,H6)

[Berna11]

Meanwhile, thanks for the answers
I'm trying to let you know
I think Bo_Ry's file is closer to my needs

[Berna11]

I think it's okay
Meanwhile I put Solved
if I have problems I will let you know
Thank you