How to change absolute cell reference with formula

Hi,

I have a table which calculates daily electricity consumption based on energy meter reading (have to enter manually).
A. column is date B. is reading from kWh meter C. calculates daily consumpion ,eg =(B20-B19)/DAYS360(A20,A19) D total period consumption, =B19-$B$2 where $B$2 is first reading of a month.
I would like use a formula which changes automatically this absolute reference to a new one at the first date of each month. Eg I need total consumption to one column which is resetted monthly.

I can figure out when the month is changed eg MONTH(A20)-MONTH(A19))>1. How can I change the absolute reference to a new one like this $B$2--->$B$19 if above formula is true?



Thanks,
Mark

Hi,

Try the following. In E20

Please Login or Register  to view this content.

and in F20

Please Login or Register  to view this content.

HTH

Thanks. Although your advice wasn't exactily what I ment, I managed with some extra editing to do what I was after.
A bit clumsy implementation but it works.