#VALUE! error message in simple sum function
 

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!

#VALUE! error message in simple sum function
 

I think you need SUM(I9,I11:I16) and AVERAGE(I9,I11:I16)
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"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!

#VALUE! error message in simple sum function
 

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

#VALUE! error message in simple sum function
 

That did it! Thank you. I thought I used the sum function in the toolbar to
set that up, but maybe I changed it along the way.

"M Kan" wrote:

I think you need SUM(I9,I11:I16) and AVERAGE(I9,I11:I16)
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"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!

#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