| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING NUMBERS IN A COLUMN | New Users to Excel | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| Adding a range of numbers associated with various dates | Excel Discussion (Misc queries) | |||
| Adding a % value to a column of numbers | Excel Worksheet Functions | |||
| Adding Column of mixed data omitting the dates | Excel Discussion (Misc queries) | |||
Threaded Mode
