Average of a row if there are more than 2 entries

Eyeseeh50 · January 16, 2020, 9:10pm

I would like to average a row of cells when there is at least 2 entries in the row.
I tried this =IF(COUNT(E6:I6, >2),AVERAGE(E6:I6), “”) but it failed.
Can someone please correct me.
Thank you.

Xander · January 16, 2020, 9:21pm

=IF((COUNT(E6:I6) >1,AVERAGE(E6:I6), “”)

Note I use ; as separtor so
=IF((COUNT(E6:I6) >1;AVERAGE(E6:I6); “”)

anon73440385 · January 16, 2020, 9:28pm

Did you test your formulas before posting? getting #VALUE!

Eyeseeh50 · January 16, 2020, 9:32pm

Sorry but that gives me #value! as an error when there is an entry and #DIV/0! when no entries

anon73440385 · January 16, 2020, 9:32pm

Hello,

your formula has the bracket at the wrong position COUNT(E6:I6, >2) - condition should read COUNT(E6:I6)>=2, thus

=IF(COUNT(E6:I6)>=2;AVERAGE(E6:I6); "")

Tested using LibreOffice:

Version: 6.3.4.2,Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US,Calc: threaded

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

Eyeseeh50 · January 16, 2020, 9:35pm

Thank you very much, that does the trick.