Formula needed. Take cumulative value and make monthly value.

[IluvPivots]

Column H gives the cumulative value for the year (by month.) So if in October you spent $5 and November you spent $5, Novembers cumulative amounts is $10 and so on.
Column E is the category of expenses. I need a formula that will return what the monthly value would be for a specific category. I hope that makes sense! This file has multiple fiscal years. I don't think that the formula should have to evaluate columns C or D. DBC is a unique code and would address these.
Please and Thank you!

 

[DanteAmor]

Hi @IluvPivots .
Thanks for posting on the forum.

This is what you need?
I highlighted a couple of examples:

Dante Amor
	A	B	C	D	E	F	G	H	I
1	FY	BUD	DOL	CIV MIL	DBC	MONTH	PERIOD	CUM	MONTH
2					4410	OCT		77,679.62	77,679.62
3					4510	OCT		1,489.09	1,489.09
4					4610	OCT		22,698.34	22,698.34
5					4710	OCT		84,279.20	84,279.20
6					4419	OCT		71,135.30	71,135.30
7					4519	OCT		10,450.86	10,450.86
8					4410	NOV		45,212.98	122,892.60
9					4510	NOV		32,939.18	34,428.27
10					4610	NOV		12,573.92	35,272.26
11					4710	NOV		58,494.36	142,773.56
12					4419	NOV		3,675.50	74,810.80
13					4519	NOV		61,922.80	72,373.66
Hoja2

Cell Formulas
Range	Formula
I2:I13	I2	=SUMIF(E$2:E2,E2,H$2:H2)

Note XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

If it's not what you need, maybe you should explain the examples you put in your image.

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

 

[IluvPivots]

Hi @IluvPivots .
Thanks for posting on the forum.

This is what you need?
I highlighted a couple of examples:

Dante Amor
	A	B	C	D	E	F	G	H	I
1	FY	BUD	DOL	CIV MIL	DBC	MONTH	PERIOD	CUM	MONTH
2					4410	OCT		77,679.62	77,679.62
3					4510	OCT		1,489.09	1,489.09
4					4610	OCT		22,698.34	22,698.34
5					4710	OCT		84,279.20	84,279.20
6					4419	OCT		71,135.30	71,135.30
7					4519	OCT		10,450.86	10,450.86
8					4410	NOV		45,212.98	122,892.60
9					4510	NOV		32,939.18	34,428.27
10					4610	NOV		12,573.92	35,272.26
11					4710	NOV		58,494.36	142,773.56
12					4419	NOV		3,675.50	74,810.80
13					4519	NOV		61,922.80	72,373.66
Hoja2

Cell Formulas
Range	Formula
I2:I13	I2	=SUMIF(E$2:E2,E2,H$2:H2)

Note XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

If it's not what you need, maybe you should explain the examples you put in your image.

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

Thank you for the response. Unfortunately I am working from a secure computer that does not allow me to download XL2BB.
The formula provided isn't exactly what is needed. It should be returning the difference between OCT and NOV.

 

[DanteAmor]

So if in October you spent $5 and November you spent $5, Novembers cumulative amounts is $10 and so on.

So I didn't understand your example.

In your image the "I" column is empty, I suppose that's where you want the result.

So, as I mentioned before, you should give examples with results, and if possible explain a couple of examples so that I can understand what the result you want is.

 

[Alex Blakenburg]

Give this a try, put it in I2 and copy it down.

=H2-IFERROR(LOOKUP(2,1/($E$1:E1=E2),$H$1:H1),0)