Tag Archives: averageif

15-significant-digit issue with SUMIF(S), COUNTIF(S), AVERAGEIF(S)

Posted on January 24, 2015 by MF

Have you applied SUMIF or COUNTIF to a range that contains numbers with more than 15 digits stored as text? If you did or if you do, you’d better continue to read this as you’ve got wrong answers that you … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 10 Comments