Formula to look at a list of names and sum another column once per name
This is kinda confusing. But I've been working on a formula to look at a list of campaign names in one column and sum the number of ads in the 2nd column per team per week, but the team may work on one campaign more than once that week but it should only be counted as the proper number of ads for that campaign. So, for the example below showing week 9 for proofreading team, the correct number I want to return is 24 total ads worked.
Help Article Resources
Check out the Formula Handbook template!