Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Columns
Hi All,
I have the Following in my worksheet A1 contains a month end date for eg. 30-04-05 B2 C2 ..... AK2 AM2 31-1-03 28-2-03 ..... 31-12-05 TOTAL 100 250 ..... 425 xxxx 250 150 ..... 200 xxxx I want to get the total based on the date in my A1. For eg if A1 containd 31-3-04 in my AM3 the total shud be sum(B3:P3) (31-01-03 to 31-03-04) so when ever I change the date in my A1 my total column shud take from 31-1-03 up to the column in which the same date appears. Is there an easy way to acheive this either thru code or formulae? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |