SUM values based on duplicate rows?

[SOLVED]

Hey All,

I'm having trouble matching some data as one of the sources provides duplicates. Here's an example:
https://adam-up.tinytake.com/sf/NzUxNDAzXzM0MzgwMDU

What I'm trying to do is sum the spend values where there are duplicates (eg. rows 2 + 3 are both campaign 1 and Computer), and then match this info to the corresponding revenue on the right that matches the Campaign ID and Device Type.

I've just spent like 4 hours playing around with SUMIFS and can't figure it out. Any help would be MUCH appreciated!

Thanks

Welcome to Excel Forum, Spiphix. One of the features that makes this a special place is the ability to upload spreadsheets. To upload a spreadsheet press the "Go Advanced" button below the "Quick Reply" box. Scroll down to Manage Attachments to open the upload window.
That said and if I understand it would seem that you could use a formula like the following in I2 and down:

Formula:

=SUMIFS(B$2:B$10,C$2:C$10,H2,D$2:D$10,G2)

Let me know if you have any questions.

You're Welcome and thank you for the feedback. BTW to mark the thread 'Solved' use thee thread tools link above your first post. I hope that you have a blessed day.