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.


  • J Tech
    J Tech ✭✭✭✭✭


    You could try:

    =SUMIFS({Project: Number of Ads}, {Campaign Name}, [Campaign Name]@row, {Service Provided}, [Service Provided]@row, {Week Number}, [Week Number]@row)


    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!
  • lrmerlino88886
    edited 03/17/23

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!