Sumifs match @row
We are keeping stats on one sheet named, "2024 STATS..." using SumChild formulas to roll up the daily stats per week, per month, per Doctor in the office. I'm trying to get the combined total for the clinic, for each stat to appear on another Sheet called, "Stats Metrics." To ensure the stats are coming from the correct week for each Doc. I'd like for the number in the [Week of the Year] column on the "Stat Metrics" to match the number from the "2024 Stats.." sheet.
Current Forumla : #incorrect Argument Set.
=SUMIFS({2024 STATS (Leap Year) new pat}, {2024 STATS (Leap Year) wk of yr}, "[Week of the Year]@row", MATCH([Week of the Year]@row))
Any suggestions?
Answers
-
What happens if you get rid of the quotes from around the cell reference and get rid of the MATCH piece entirely?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
The formula works but is producing the wrong total and I'm not sure where it is coming from... Formula is saying the collective total for the Jan. Wk1 is "60" When is should only be 30.
-
Have you tried applying a matching filter to the source sheet?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I'm not sure I understand what you are referring to.
-
A filter applied to the source sheet that mimics that range/criteria sets from your formula. So a filter on the source sheet to show all rows that meet the criteria in the week of the year column as you have written out in your formula.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!