Find total due according to date

adiles

New Member
Joined
Jun 13, 2020
Messages
37
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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,065
Office Version
  1. 365
Platform
  1. Windows
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)
 
Solution

adiles

New Member
Joined
Jun 13, 2020
Messages
37
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

You are welcome. :)
Sir,

Is it possible to create a formula which will display "Cancelled" if the other cell is displayed in red (conditional formatted cell)

SMWCancelled
UTRCancelled
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,065
Office Version
  1. 365
Platform
  1. Windows
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.
 

adiles

New Member
Joined
Jun 13, 2020
Messages
37
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,708
Messages
5,654,856
Members
418,155
Latest member
demasisi

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
Top