Add cell values for any matching data in range

[chaztin]

Hello everyone,
I am posting here after looking for multiple options/ways this could be done but couldn't find an answer.

So I am posting it with an example.
I want the data within the columns to be compared first, for eg. from if data is compared within the column, A2 to A5 are duplicates, B2 to B5 are duplicates and so forth.
For this duplicate range, I want to be able to add the COLUMN5 data and get a result in any cell in that range in F/Results column.
So it will only add cells from within column E if data in other columns (within columns matches). I hope it makes sense?
I have highlighted the result.

Even if there is another way to do it without formulas, answers are most welcome.
Please note that this is just an example, in the actual file data goes as far as row 2799
Thank you
Captured.JPG

[Phuocam]

Try this in F2:

=IF(AND(A2<>A3,B2<>B3),SUM($E$2:E2)-SUM($F$1:F1),"")

[chaztin]

Try this in F2:

=IF(AND(A2<>A3,B2<>B3),SUM($E$2:E2)-SUM($F$1:F1),"")

Thank you for a reply.
Its returning blank cell when pasted in F2.

[Phuocam]

Hi;

Can you upload the file and the expected results?

[JohnTopley]

With

=IF(AND(A2<>A3,B2<>B3),SUM($E$2:E2)-SUM($F$1:F1),"")

F2 will be blank but F5 will have 200 and F13 has 380 (as per your post)

BUT need to add tests for columns C & D