Forum Discussion
Display Sum Values Based on Inches
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.
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!
What that tells me is that you have an older version of Excel. The FILTER function requires Excel 2021 or newer. I would recommend you update. It's worth it. That's not the only new feature, and especially if you're doing array manipulations, you'll find a number of very powerful functions, FILTER being only one.
Here, to tempt you, a video that formed my own introduction to FILTER, UNIQUE and SORT..... These functions have given a whole new lease on life.
https://www.youtube.com/watch?v=9I9DtFOVPIg