Find total due according to date

adiles

New Member
Joined
Jun 13, 2020
Messages
41
Office Version
  1. 365
Platform
  1. Windows
Dear All,

I want a formula which will sum monthly amount in due column in accordance with the current month.

What I want is, if the amount is 120 and it should display 120*2="240" in the total due column after 28th february, and when it comes to March 31st it should display 120*3=360 and so on.

AmountTotal Due
120​
240
110​
220
195​
390
130​
260
145​
290
130​
260
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Is this what you mean?

21 03 16.xlsm
AB
1AmountTotal Due
2120240
3110220
4195390
5130260
6145290
7130260
Due by month
Cell Formulas
RangeFormula
B2:B7B2=A2*(MONTH(TODAY())-1)
 
Upvote 0
Solution
This seems to be a completely different question so you start a new thread for it.
When you do, you should explain what the condition is that turns the cells red because that same condition should be able to be used to produce the "Cancelled" result.
 
Upvote 0
This seems to be a completely different question so you start a new thread for it.
When you do, you should explain what the condition is that turns the cells red because that same condition should be able to be used to produce the "Cancelled" result.
Sure, Thanks.
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,150
Members
453,021
Latest member
Justyna P

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