| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if the column heading is in the past?
If your first row contains the months (real dates, not text) and if you have
a sum row for each column at the bottom (in my example it is row 11), then this formula: =SUMPRODUCT(--(1:1<""),--(1:1<=NOW()),11:11) will calculate the sum of all the months which are before today's date. Let me know in case I have misunderstood your request! -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column help- can I go past IV? | Excel Discussion (Misc queries) | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
| Can I add more columns in Excel past column IV | Excel Discussion (Misc queries) | |||
| column heading | Excel Discussion (Misc queries) | |||
| Need to put a name in the column heading | Excel Discussion (Misc queries) | |||
Threaded Mode
