SUMIFS help in summary panel
Answers
-
And I have another question. We have different software programs that I also need to break out into weeks, months and years. Where in the SUMIFS formula would I enter the name of the software?
-
Hey @Angie F
I'm glad you got it to work! I'll answer each of your comments separately.
Since you have a Year column in your sheet, all you have to do is add the Year column as a range and then the criteria of the year you're looking for.
=SUMIFS([NET HOLD]:[NET HOLD], [WEEK #]:[WEEK #], @cell = WEEKNUMBER(TODAY()), YEAR:YEAR, 2023)
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
To filter by a different value, again, all you need is to enter the Column, comma, criteria. Think of it like a filter, where you select the column, then add in what you're looking for.
=SUMIFS([NET HOLD]:[NET HOLD], [WEEK #]:[WEEK #], @cell = WEEKNUMBER(TODAY()), YEAR:YEAR, 2023, SOFTWARE:SOFTWARE, "Golden Dragon")
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P. thank you so much for all of your help!
-
@Genevieve P. would the formulas look the same if I am referencing another sheet? I need to set up a metrics sheet for each software program and will be referencing the raw data sheet I have been working with. The formulas will need to look for a specific owner and the software name when it sums the data.
-
Hi @Angie F
The structure of a SUMIFS will stay the same, but the way you create your column references will be different.
You'll need to replace any in-sheet reference with a cross-sheet reference.
=SUMIFS({Net Hold Column}, {Week Number Column}, @cell = WEEKNUMBER(TODAY()), {Year Column}, 2023)
Here's more information: Create cross sheet references to work with data in another sheet
And a free webinar that goes through how to make references: Essential Formulas for Smartsheet Users
An alternative would be to create a Row Report, filtering by Date Range and Year, then Group by the Software Name, and use Summary to SUM your values. Here's another webinar that explains Reports: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
