#VALUE! error message in simple sum function
Thank you. Solved my problem.
"Dave Peterson" wrote:
I think you want:
=sum(i9,i11:i16)
Same with the =average() function.
Sandog wrote:
I am getting a weird error message doing the simplest sum function. I have a
column with 10 filled cells, I7-I16. In a cell below that I enter
=SUM(I9+I11:I16). Same with average: =AVERAGE(I9+I11:I16). I imagine I'm
doing something dumb, but this is driving me whacko!
--
Dave Peterson
|