# Find total due according to date

##### New Member
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.

 Amount Total 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
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)

##### New Member
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)
Thanks alot.

#### Peter_SSs

You are welcome.

##### New Member

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)

 SMW Cancelled UTR Cancelled

#### Peter_SSs

##### MrExcel MVP, Moderator
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.

##### New Member
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.

Replies
10
Views
70
Replies
0
Views
166
Replies
0
Views
49
Replies
1
Views
232
Replies
7
Views
1K

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.

### Which adblocker are you using?

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

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