[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
Bookmarks