Auto increment (Reconciliation of Prepaid Expenses)

[Paulm9]

Good afternoon,

I want to make an auto increment in my cell formula. The idea is every time I put a check mark , it will increase by 1.
For example:

10/16-12/16			350,000.89
			=-116,666.96*2	($116,666.96/ month 2 of 3)
			=116,666.97

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

I want it to be

=-116,666.96*3

($116,666.96/ month 3 of 3)

<tbody>
</tbody>

Please advise or where I can find similar idea.

Thanks

 

[Dave Patton]

Excel 2010
	B	C	D	E	F
1		Prepaid Balance
2	Total	Oct-16	Nov-16	Dec-16	Balance
3	350,000.89	v	v	v	0
4
2e

Cell Formulas
Range	Formula
F3	=B3-COUNTIF(C3:E3,CHAR(63))/3*B3

 

[Paulm9]

Really appreciate for your help.
My prepaid rec spreadsheet have 12 tabs, 1 for each month. For every tab, I have different clients, some need to increase the amortization, some not.
I wonder around our forum and seeing some using INDIRECT. Do you have any idea using INDIRECT for this?

Oct2016 tab:

1		Chipotle	3/16-2/2017		16,480.00
		Amortization			(12,359.97)	($1,373.33/ month 9 of 12)
					4,120.03

<tbody>
</tbody>

Nov2016 tab:

1		Chipotle	3/16-2/2017			16,480.00
		Amortization				(13,733.30)	($1,373.33/ month 10 of 12)
						2,746.70

<tbody>
</tbody>

Thank you in advance.

 

[Dave Patton]

Why do you have different sheets for each Month?
How do show that you want to amortize for a particular month?
Can you post a concise example of a sheet?
In the quick example below G4 is Oct 1 2016

Excel 2010
	A	B	C	D	E	F	G
4							Oct Balance
5	Name	Terms		Months	Amount
6	Chipotle	01-01-16	01-01-17	12	16,480.00	1373.33	4,120.03
2e

Cell Formulas
Range	Formula
D6	=DATEDIF(B6-1,C6,"M")
F6	=ROUND(E6/D6,2)
G6	=E6-DATEDIF(B6-1,G4,"M")*F6

 

[Paulm9]

Sorry for the late reply. Thank you for your helps. Its really nice to know this DATEDIF.