View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
piklelila piklelila is offline
external usenet poster
 
Posts: 1
Default 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?