Forum Discussion
Solved
Display Sum Values Based on Inches
Need a formula for the following array: SUM IF Sheet2!$A3 = Sheet1!$A:$A AND if Sheet1!$Z:$Z is more than or equal to 70 OR less than or equal to 74 then return the sum of the...
In that case, the SUMIFS should still work. Converting the data to Tables one would have
= SUMIFS(Table1[MCHUPS], Table1[Off],[@Name])BTW I agree with mathetes support for updating Excel to 2021 or 365. Once you have it, the only impediment to writing great solutions is your past experience of spreadsheets!
The spreadsheet tells me that the FILTER function isn't valid, so the formula doesn't work. I have double-checked that I typed it in correctly.
In that case, the SUMIFS should still work. Converting the data to Tables one would have
= SUMIFS(Table1[MCHUPS], Table1[Off],[@Name])BTW I agree with mathetes support for updating Excel to 2021 or 365. Once you have it, the only impediment to writing great solutions is your past experience of spreadsheets!
- Thank you both. I appreciate your help.