Find Consumption on monthly basis

[Muthukrishnan V]

Find consumption on monthly basis.xlsx
	A	B	C	D	E	F	G
1	Date	Daily Reading	Consumed	Explanation - Formula request for Column C		Date	Monthly Reading
2	15-11-2023	7448.36	0.36	C2=G2-B2 (Date in A2 falls between 15-11-2023 to 17-12-2023 as in F2)		15-11-2023	7448.00
3	17-11-2023	7452.00	4.00	C3=G2-B3 (Date in A3 falls between 15-11-2023 to 17-12-2023 as in F2)		18-12-2023	7726.00
4	20-11-2023	7456.28	8.28	C4=G2-B4 (Date in A4 falls between 15-11-2023 to 17-12-2023 as in F2)		15-01-2024	8198.00
5	21-12-2023	7738.40	12.40	(C5=G3-B5 (Date in A5 falls between 18-12-2923 & 14-01-2024 as in F3)
6	31-12-2023	7794.50	68.50	(C6=G3-B6 (Date in A6 falls between 18-12-2923 & 14-01-2024 as in F3)
7	16-01-2024	8201.00	3.00	(C7=G4-B7 (Date in A7 falls on or after 15-01-2024 as in F4)
8
9				Excel 365. I request you to kindly advise me formula for Column C
10				Thanking you.
11
Sheet1

 

[SunnyAlv]

Try this

=IFERROR(ABS(INDEX($G$2:$G$4,MATCH(A2,$F$2:$F$4,1))-B2),"")

 

[Muthukrishnan V]

Thank you SunnyAlv, sir. Works fine.

 

[SunnyAlv]

Thank you SunnyAlv, sir. Works fine.

No Problem

 

[Muthukrishnan V]

Find consumption on monthly basis.xlsx
	A	B	C	D	E	F	G
1	Date	Daily Reading	Consumed	Excel 365		Date	Monthly Reading
2	15-11-2023	7448.36	0.36	Sir, One more clarification and request for		15-11-2023	7448.00
3	17-11-2023	7452.00	4.00	formula. The dates in Column A are filled with		18-12-2023	7726.00
4	20-11-2023	7456.28	8.28	dates (DD-MM-YYYY). The future dates Reading		15-01-2024	8198.00
5	21-12-2023	7738.40	12.40	in B9 and B10 will be filled on relevant days.		17-01-2024	8202.00
6	31-12-2023	7794.50	68.50	I, therefore, want C9 and C10 to be blank.
7	17-01-2024	8204.00	2.00	Since B9 and B10 are blank, C9 and C10 should
8	18-01-2024	8207.00	5.00	display blank. I request you, Sir, an amendment to
9	08-02-2024		8202.00	formula in Column C. Thanking you, Sir.
10	11-02-2024		8202.00
11
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=IFERROR(ABS(INDEX($G$2:$G$8,MATCH(A2,$F$2:$F$8,1))-B2)," ")

 

[SunnyAlv]

Try this sir

in Cell "C2" and filldown

=IF(B2="","",IFERROR(ABS(INDEX($G$2:$G$8,MATCH(A2,$F$2:$F$8,1))-B2)," "))

 

[Muthukrishnan V]

Thanking you Sir for your great help. Works fine.
My respectful regards to our Forum.

 

[SunnyAlv]

No Problem, I'm glad I could help