Find total due according to date

[adiles]

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

 

[Peter_SSs]

Is this what you mean?

21 03 16.xlsm
	A	B
1	Amount	Total Due
2	120	240
3	110	220
4	195	390
5	130	260
6	145	290
7	130	260
Due by month

Cell Formulas
Range	Formula
B2:B7	B2	=A2*(MONTH(TODAY())-1)

 

[adiles]

Is this what you mean?

21 03 16.xlsm
	A	B
1	Amount	Total Due
2	120	240
3	110	220
4	195	390
5	130	260
6	145	290
7	130	260
Due by month

Cell Formulas
Range	Formula
B2:B7	B2	=A2*(MONTH(TODAY())-1)

Thanks alot.

 

[Peter_SSs]

You are welcome.

 

[adiles]

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]

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]

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.