A
Aladin Akyurek
=AVERAGE(A1:A5)
=SUM(A1:A5)/MAX(1,COUNT(A1:A5))
=SUM(A1:A5)/MAX(1,COUNT(A1:A5))
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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
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
B
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)
=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)
T
That's Confidential
Sorry, my title should have read (NO DATA IN CELL)
T
That's Confidential
Thanks All!
Problem Solved
Problem Solved
Bob Phillips said: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)