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'!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)
- For consideration, create a helper table that modifies the Lookup value by your goal amount. So there is no formula for the criteria, but instead the actual criteria in the table is already modified by your goal.
- I was trying to extract this data from a table with filters to numbers to help me process the data collectively into a table
Please explain how exactly you want to subtract the value of M5.
- I need f1-m5 added to f2-m5...
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)
