Sumifs match @row

malorie

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))

Screenshot 2023-12-26 130650.png

Screenshot 2023-12-26 1312281.png

Any suggestions?

Paul Newcome

What happens if you get rid of the quotes from around the cell reference and get rid of the MATCH piece entirely?

malorie

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.

Paul Newcome

Have you tried applying a matching filter to the source sheet?

malorie

I'm not sure I understand what you are referring to.

Paul Newcome

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.