Forum Discussion
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'!...
You cannot subtract within the SUMIFS formula. Try this:
=SUMIFS('mysummary'!F:F, 'goals'!D:D, 'goals'!F5, 'goals'!E:E,'goals'!G5)-M5*COUNTIFS('goals'!D:D, 'goals'!F5, 'goals'!E:E, 'goals'!G5)
This sadly won't work because it's not an average but thank you
Have you actually tried it? It does what you asked. If it is not what you want, please explain more clearly what you actually want to do.
- Yes I have and it doesn't, I need f1-m5 to be added but not f2, then f3-m5, and f2-m6
How does M6 come into this? Please try to provide clear and detailed information.