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.
Answers
-
Hi,
You could try:
=SUMIFS({Project: Number of Ads}, {Campaign Name}, [Campaign Name]@row, {Service Provided}, [Service Provided]@row, {Week Number}, [Week Number]@row)
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
Thank you, but this is a basic sumifs formula, it will add all of them. It returns 52. I need it to sum only the first occurance of each campaign for each week, team and person if that makes any sense..... the number I'm looking for here is 24...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!