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)

​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.eSumifs(‘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)  Read More

​