Forum Discussion
Can't find a function that works like sumifs but finds the summary column via a criteria.
I have a database I'm building that I need to reference to an old form, however, I can't seem to find a function that does what I need it to do. One of my favorite formulas is the SUMIFS, which I ca...
You could use a double XLOOKUP like this:
=XLOOKUP(F2&F3,dept&code,XLOOKUP(F1,months,data))My example only uses two criteria but you get the idea.