If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding numbers in a column with dates
I have a column with dates and numbers. I want to add up the numbers at the
bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? |
#2
|
|||
|
|||
adding numbers in a column with dates
Are the other values text ('11/15) or really numbers?
If they're really text, you could use: =sum(a1:a10) Text values will be ignored. If they're really numbers (maybe dates???), then this won't work for you. I'd add another column that would be used as an indicator. Put an X in the row if that value in column A should be summed. =sumif(b:b,"x",a:a) If those 11/15's are really dates, and the values aren't very big, you could use a fromula like: =sumif(a:a,""&date(2000,1,1)) Dates are just numbers to excel. And Jan 1, 2000 is 40177 (with 1904 as the base year). piklelila wrote: I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? -- Dave Peterson |
#3
|
|||
|
|||
adding numbers in a column with dates
Are the numbers to sum *always* in the even numbered rows?
Are the numbers to sum *always* less than a certain value? For example, the numbers to sum *will never* be greater than 100. In Excel dates are really numbers that are formatted to look like dates. Today's date is 12/30/2009. It *displays* as the date 12/30/2009 but its true value is the number 40177. Trying to differentiate numbers from dates can be complicated so we have to try to come up with some kind of logical rule that distinguishes the numbers to sum from the number dates. -- Biff Microsoft Excel MVP "piklelila" wrote in message ... I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? |
#4
|
|||
|
|||
adding numbers in a column with dates
Here's a couple ways, depending on the relativity of your dates to
numbers........ =SUMIF(A:A,""&9000) =SUMIF(A:A,""&"12/1/2009") Vaya con Dios, Chuck, CABGx3 "piklelila" wrote in message ... I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? |
#5
|
|||
|
|||
adding numbers in a column with dates
Hi,
If the sample data you gave is typical then you want to sum even numbered rows so try this =SUMPRODUCT((1-MOD(ROW(A1:A10),2))*A1:A10) Mike "piklelila" wrote: I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? |
#6
|
|||
|
|||
adding numbers in a column with dates
It's not good design to mix dates and numbers in the same column: break them
out into 2 separate columns. If my comments have helped please hit Yes. "piklelila" wrote: I have a column with dates and numbers. I want to add up the numbers at the bottom of the column. For example: A1 11/15 A2 33 A3 11/20 A4 45 A5 11/24 A6 66 etc... I just want to add A2, A4, A6, etc.... Is there an easy way to do this? I know that I can single out by =SUM(A2,A4,A6), but there are a lot more to add in the column and I'll be doing it for each month. This way would be so tedious and time consuming. Can anyone help? |
Thread Tools | |
Display Modes | |
|
|