Hi,

Since the next no. will always be = the previous number, you simply want
the difference between the maximum and the minimum number

=max(range)-C5

where C5 is the first value.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"
rosoft.com wrote in
message ...
I have some meter readings in a weekly spreadsheet. they count for ex.
3222
3333
3422
I need to count only the increase in each cell. ex between the first two
would 111 the 2-3 would be 89. I need to be able to total the usage of
week.
Help with a formula please.

thank you