No date in cell

[Aladin Akyurek]

=AVERAGE(A1:A5)

=SUM(A1:A5)/MAX(1,COUNT(A1:A5))

 

[That's Confidential]

If I want to work out the average sum of say, for example, 5 cells in a
row, I would simply write =SUM(A1:A5)/5 in this case. If however, I wanted
the computer to work out the average of the sum in a number of cells, only
if there was data in the cells, how would I write this? Say for example, I
have 5 cells in a row, with no data in one of the cells. That would effect
the average, so how do I write a formula whereby, if there is no data in the
cell, then the formula will ignore that cell???

Thanks

 

[Bob Phillips]

Use the AVERAGE function

=AVERAGE(A1:A5)

it caters for the blanks

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[That's Confidential]

Sorry, my title should have read (NO DATA IN CELL)

 

[That's Confidential]

Thanks All!

Problem Solved

Use the AVERAGE function

=AVERAGE(A1:A5)

it caters for the blanks

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)