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?
-
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?
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!