SUMIFS producing #VALUE!

Hi BMV, the issue you outlined applies only to the COUNT function, not the SUM.

the attached is taken from an old thread but something I use to highlight the issue when it comes up for discussion - as this isn't documented.

The 5k COUNTIFS will calc in ~17s (on my machine) whereas SUMIFS will take 0.1s
(sometimes, if being used in large volume, I will advise people to add the 1 field so they can SUMIFS in preference to COUNTIFS)

FWIW, @XOR LX corrected me to the same effect as I saw the issue with COUNTIFS and presumed it applied to all - but it does not (thankfully!)