Sum that changes based on "paid date" and "paid amount"

**savage** · 05-31-2012, 10:19 PM

bills.xlsx

this worksheet is helping me manage my money (eventually), but I am having trouble with a formula. I want the cell highlighted in yellow to show me the total left to be paid in the month.

I might be adding to this worksheet a table of days i get paid and how much, but i haven't decided how to implement it yet.

Criticism and suggestions are welcome.

**vlady** · 05-31-2012, 10:38 PM

Hello
try sumifs

=SUMIFS(B2:J2,B4:J4,">="&TODAY())

**savage** · 06-01-2012, 05:43 PM

Do you have any suggestions on how i should implement the days I get paid and how much?

**savage** · 06-01-2012, 08:50 PM

Originally Posted by vlady

Hello
try sumifs

=SUMIFS(B2:J2,B4:J4,">="&TODAY())

This seems to be adding even if the bill hasn't been paid yet.
example: i added it to the next section and it shows $10 even though its not the 29th yet.

**vlady** · 06-02-2012, 01:32 AM

Oopps sorry that's supposed to be less than and equal <= not greater than and equal.

**RobertMika** · 06-02-2012, 06:30 AM

SUMIF will be suffiecient and work for all Excel version
=SUMIF(B4:J4,"<="&TODAY(),B2:J2)

Sum that changes based on "paid date" and "paid amount"

LinkBack

Thread Tools

Rate This Thread

Display

Sum that changes based on "paid date" and "paid amount"

Re: Sum that changes based on "paid date" and "paid amount"

Re: Sum that changes based on "paid date" and "paid amount"

Re: Sum that changes based on "paid date" and "paid amount"

Re: Sum that changes based on "paid date" and "paid amount"

Re: Sum that changes based on "paid date" and "paid amount"

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions