Want to total the amount of one column on the condition that a date is entered in another column. See attachment for example. This is to track the total of invoices that have been paid.
Want to total the amount of one column on the condition that a date is entered in another column. See attachment for example. This is to track the total of invoices that have been paid.
Try this formula in F1.Formula:Please Login or Register to view this content.
This only works because dates are numbers. I know of no other test for dates than to test if it is a number. The downside is if you enter any other number that is not a date into column F it will return incorrect results in F1.
You also have column F (including F1) formatted as Text. This can cause problems for calculations later. Try changing the formatting for F1 to General. You may need to recommit that formula. Then apply Text to columns to the rest of the data in column F (it's in the Data ribbon) > choose Delimited > Next > then clear all the delimiter boxes > Next > then choose the date format > Finish.
Dave
This is a duplicate thread.
That does not work.
Better explanation of what I need. In the attached file it should be E not F.
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.
Thank you. Your in-sheet instructions said column "F". I wondered about that.
Column C are dates. Do you mean column B? TryWhen a date is added in column E, it will add total amount from column C to running total in F1.
Formula:Please Login or Register to view this content.
Thank you FlameRetired that worked perfectly.
You can also use sumif formula here
=SUMIF(E4:E18,"="&"",B4:B18)
Need more help? Visit livespreadsheethelp.com for free, instant match, personalized help from paid certified experts in Excel.
Last edited by guru008; 12-07-2016 at 12:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks