| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple message box question | Excel Discussion (Misc queries) | |||
| Simple message box question | Excel Discussion (Misc queries) | |||
| Simple Checkbox Message Code | Excel Discussion (Misc queries) | |||
| Error message when inserting function | Excel Discussion (Misc queries) | |||
| changing the message in an error message | Excel Worksheet Functions | |||
Linear Mode
