Hi, sorry for noob question, but I cannot seem to make this work.

each line of my worksheet can contain from 1 to 6 entries
I want to average those but I don't know how to "turn off" the columns
that are null & therefore I get DIV/0 error.

EG:

A1 = 10, A2 = 10, A3 = 10, A4 = 10, A5 = 10, A6 = 10
B1 = 10, B2 = 10, B3 = 10
C1 = 10, C2 = 10, C3 = 10, C4 = 10

In all 3 examples, the Average is 10 (across the line, not down the
column)
I tried Nesting IF functions, eg: IF(A6=0, AVG(A1:A5), IF(A5=0,
AVG(A1:A4)) & so on

Can someone please help me figure out a formula that will average the
line items & ignore the blank cells

thanks a ton,

Kart