Average of a row if there are more than 2 entries

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.

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

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

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

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


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:,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 (:heavy_check_mark:) next to the answer.

Thank you very much, that does the trick.