| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need to sum values of columns 1 - 13 and 4 - 15
I have many rows of data and need to sum values in the first 13
columns (col 1 - 13) and starting from the column a value first appears. For example a value appears in Col 5 for the first time. I want to start summing the values for the next 12 columns. And then I also want a sum for the same row from the Col 9 (as it contains the 4th value) to Col 15. Jan Feb Mar Apr May June July Aug Sept Oct 352 450 560 700 70 80 I want the sum of the first 13 values starting from May and Sum of next set of values starting from Aug. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| How do I get unique values from 2 columns? | Excel Discussion (Misc queries) | |||
| Creating a chart with values from two columns | Charts and Charting in Excel | |||
Threaded Mode
