Can someone explain the advantages/disadvantages of SUMIFS vs. array formulas?
I've been a long time user of arrays when creating formulas that needs multiple conditions. But I've noticed some people here (most notably, Ace_XL) using SUMIFS, which I think is very elegant and easy to understand/explain.
I know arrays are somewhat clunky... lots of computing power and error prone (with bad data)... plus trying to explain Ctrl-Shift-Enter to a noobie...
I haven't explored SUMIFS to its fullest, but with little testing, it's been a great formula.
However, does it have the same pitfalls as using arrays? (except no more Ctrl-Shift-Enter!)
Thanks,
Dennis
Bookmarks