Thanks:  0
Likes:  0

# Thread: Conditional Sum - I suppose??

1. 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

2. Hi Paul

Let's say the dates are in Column "A"
Cell holding the needed date is C1
The values to add are in Column "B"

=SUMIF(\$A\$1:\$A\$1000,\$C\$1,\$B\$1:\$B\$1000)

Should help

_________________
Kind Regards
Dave Hawley
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-28 06:26 ]

3. Paul,
It sound like a sumif statement may meet your needs. The format would be
=SUMIF(A1:A13,">"&C1,B1:B13)

where A1:A13 is payment dates and B1:B13 are corresponding payments. C1 would be the date your user entered. The would show all payments after this date. To be inclusive of that date simply change it to >=.

good luck

Or what dave said

[ This Message was edited by: IML on 2002-03-28 06:26 ]

[ This Message was edited by: IML on 2002-03-28 06:27 ]

4. Problem Solved - Many Thanks.

You've no idea the "pain" my ignorance has cuaused me over the last 3 months!!!

Cheers - Paul

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•