Conditional Running Total ???

Mulder030

New Member
Joined
Apr 29, 2017
Messages
4
G'day, Hope someone can help me out.

I have created a spreadsheet to track my work flow. I was hoping to have a dollar value in a certain cell that shows me my next incoming payment from the client.
it is currently keeping a running total of what I have been paid to date which is calculated from the H column. But thought it would be nice to have a quick reference cell showing my next incoming payment.
(please refer below)


So what i was thinking is
IF a cell in 'column F' has '100%', a date populated in the 'G column' and nothing in the H column. then add $25 to cell D5. (payment per job is a flat fee of 25 and never fluctuates)
D5 might not have a figure if I have just been paid and am back to square for the month.

I would be happy to create additional cells to make this work if it would be easier for my 'Next Payment Total' to reference another cell.

Any help would be appreciated.
Regards.
Mulder






 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
try this, amend ranges to suit

=25*COUNTIFS(E9:E100,1,F9:F100,"<>"&"",G9:G100,"="&"")
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,463
Members
453,725
Latest member
cvsdatreas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top