# Need a formula to calculate a total in one column when a date is added in another column.

1. ## Need a formula to calculate a total in one column when a date is added in another column.

Attached example. I want to be able to have a running total of paid invoices. When I enter a date that the invoice is paid the invoice amount will be added to the total. I guess its like an if or sumif but don't know.

Thanks

2. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

Why and where is date in column F (which is "Invoice Number")?

Add sample results to your posted file.

3. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

Sorry not column F but column E

4. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

This is a duplicated thread with answer. http://www.excelforum.com/showthread...78#post4537178

5. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

I know website was acting weird earlier do not think this one went through. So I reopened site and just made it in general forum. O'well neither have been answered correctly yet.

Better explanation of what I need.
When a date is added in column E, it will add total amount from column C to running total in F1.
If the cell is blank nothing is done but once the date is added it will add invoice amount to total.

6. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

I know website was acting weird earlier do not think this one went through. So I reopened site and just made it in general forum. O'well neither have been answered correctly yet.

Better explanation of what I need.
When a date is added in column E, it will add total amount from column C to running total in F1.
If the cell is blank nothing is done but once the date is added it will add invoice amount to total.

7. ## Re: Need a formula to calculate a total in one column when a date is added in another colu

Try

=SUMIF(E:E,">0",B:B)

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1