Hi all,
I have a worksheet with one row per day covering a period of 5 years. The columns are "amounts paid by subscribers" with amounts entered on the day (row) they were paid, i.e. a matrix format. The "user" selects a date using drop down boxes. I have formatted the date to match that in the main worksheet. I would now like to show cumulative payments by any given subscriber at the date selected by the "user". I have tried to weld the SUM function onto LOOKUPs etc but with no success. I do not want to add additional "cumulative payment columns" for each subscriber (then use LOOKUP). How do I make the SUM formula sensitve to a variable date?
Any help greatly appreciated.
Cheers - Paul
I have a worksheet with one row per day covering a period of 5 years. The columns are "amounts paid by subscribers" with amounts entered on the day (row) they were paid, i.e. a matrix format. The "user" selects a date using drop down boxes. I have formatted the date to match that in the main worksheet. I would now like to show cumulative payments by any given subscriber at the date selected by the "user". I have tried to weld the SUM function onto LOOKUPs etc but with no success. I do not want to add additional "cumulative payment columns" for each subscriber (then use LOOKUP). How do I make the SUM formula sensitve to a variable date?
Any help greatly appreciated.
Cheers - Paul