Forum Discussion
mcammon2001
Apr 22, 2024Copper Contributor
Excel Sumifs help
I need to use a sumifs formula to add up a group of numbers with 3 different criterias, and it also needs to subtract my varying goal for the day. I.e Sumifs('mysummary'!F:F,'goals'!D:D,'goals'!...
mcammon2001
Apr 22, 2024Copper Contributor
Yes I have and it doesn't, I need f1-m5 to be added but not f2, then f3-m5, and f2-m6
HansVogelaar
Apr 22, 2024MVP
How does M6 come into this? Please try to provide clear and detailed information.