Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum sections of data
I have a multiple groups of data with line breaks between each. I would like
to sum the column and in the output cell, have the SUM equation. I want this because I may change one of the value and would want it to update automatically. 7 5 6 6 9 33 (<-output cell) 5 6 2 1 1 0 1 16 (<-output cell) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum sections of data
I'm thinking something like
=SUM(A1:A10) would do or did you want this with VBA? "Brian" wrote: I have a multiple groups of data with line breaks between each. I would like to sum the column and in the output cell, have the SUM equation. I want this because I may change one of the value and would want it to update automatically. 7 5 6 6 9 33 (<-output cell) 5 6 2 1 1 0 1 16 (<-output cell) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum sections of data
Brian wrote:
I have a multiple groups of data with line breaks between each. I would like to sum the column and in the output cell, have the SUM equation. I want this because I may change one of the value and would want it to update automatically. 7 5 6 6 9 33 (<-output cell) 5 6 2 1 1 0 1 16 (<-output cell) Do these work? =SUM(A1:A5) =SUM(A8:A14) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum sections of data
I would want VBA to populate this field. They are not all the same amount of
rows of data. I would like the SUM equation to be inserted in the blank row right below the data, them move down to next section of data and sum those (leaving the sum equation in the cell). "Barb Reinhardt" wrote: I'm thinking something like =SUM(A1:A10) would do or did you want this with VBA? "Brian" wrote: I have a multiple groups of data with line breaks between each. I would like to sum the column and in the output cell, have the SUM equation. I want this because I may change one of the value and would want it to update automatically. 7 5 6 6 9 33 (<-output cell) 5 6 2 1 1 0 1 16 (<-output cell) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging Sections of data | Excel Worksheet Functions | |||
SUMIF with sections of data | Excel Programming | |||
Copy Paste sections of data | Excel Worksheet Functions | |||
Worksheet Sections | Excel Discussion (Misc queries) | |||
Delte blank rows between different sections of data | Excel Programming |