sum if

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The problem that I am having is that I have to 12 columns (12 months imagine) with data and I want to have a column at the end which when I am entering each month to sum all the previous months also. For example if I chosse to M3 to sum M1 M2 M3. I trying to do it so by entering 12 if functions but is not working. Do you have any other way to suggest.
 
Hi Jimbo
If your data is in say, Column A.
At the bottom of column A, type =SUM(A1:A12), or whatever
your last cell of data is.
You can then drag that formula across the columns by
grabbing the fill handle in the bottom right of the cell.
Then go one more column to the right and type =SUM(A12:L12)

A simpler method is to use the Autosum function on the
toolbar which is denoted by the Sigma sign or a Greek
looking "E"
Regards
Michael
-----Original Message-----
The problem that I am having is that I have to 12 columns
Click to expand...
(12 months imagine) with data and I want to have a column
at the end which when I am entering each month to sum all
the previous months also. For example if I chosse to M3 to
sum M1 M2 M3. I trying to do it so by entering 12 if
functions but is not working. Do you have any other way to
suggest.
 
Probably I was not clear to what I was asking! I ll try to make as clear as I can. I am having 12 columns (12 months) in a worksheet with data and what I am trying to do is to create an extra column which will operate as a plug and by entering each time one month will sum all the previous months. Let me give one example

M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12 M
1 2 3 4 5 6 8 21 56 45 12 13

When I enter for example at the last column (PLUG COLUMN) M4 to sum also M1 M2 M3 M4 and to do this for
each month.IF($P$7=1,SUM(C8),IF($P$7=2,SUM(C8:D8),IF($P$7=3,SUM(C8:E8),IF($P$7=4,SUM(C8:F8),IF($P$7=5,SUM(C8:G8),IF($P$7=6,SUM(C8:H8),IF($P$7=7,SUM(C8:I8))))))))This is the formula that I am trying to use but is not suming after month 7. P is the last column. Do you have any other way to suggest.
 
Back
Top