AVERAGE and AVERAGEA returning the same amount

This is what is happening in my spreadsheet
J10 = 1
J11 = blah
J12 = 4
=AVERAGE(J10:J12) returns 2.5
=AVERAGEA(J10:J12) returns 2.5

This is what I would expect
=AVERAGE(J10:J12) returns 2.5
=AVERAGEA(J10:J12) returns 1.67

2 Likes

Thanks! This is a bug and we are tracking this internally as BUG-003663. Will update this thread when resolved.

1 Like

Issue #003663 has been fixed with the latest upgrade

2 Likes