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
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
Why and where is date in column F (which is "Invoice Number")?
Add sample results to your posted file.
Sorry not column F but column E
This is a duplicated thread with answer. http://www.excelforum.com/showthread...78#post4537178
Dave
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.
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.
Try
=SUMIF(E:E,">0",B:B)
Last edited by JohnTopley; 12-07-2016 at 03:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks