Apr 22 2024 12:27 PM
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'!F5,'goals'!E:E,'goals'!G5) but each of those numbers need to subtract my goal set for the day in theory a
Sumifs('mysummary'!F:F,'goals'!D:D-M5,'goals'!F5,'goals'!E:E,'goals'!G5)
Apr 22 2024 12:58 PM
Please explain how exactly you want to subtract the value of M5.
Apr 22 2024 01:04 PM
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)
Apr 22 2024 01:09 PM
Apr 22 2024 01:44 PM
Apr 22 2024 01:45 PM
Apr 22 2024 01:57 PM
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.
Apr 22 2024 02:04 PM
Apr 22 2024 02:17 PM
How does M6 come into this? Please try to provide clear and detailed information.