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'!...
Forum Discussion
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
