Formula needed for counting

  • Thread starter Thread starter Jthompson
  • Start date Start date
J

Jthompson

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
 
I need to be able to total the usage of week.

With your data in the range A2:A4

=SUMPRODUCT(A3:A4-A2:A3)

Note how the ranges in the formula are offset.

--
Biff
Microsoft Excel MVP


"(e-mail address removed)"
 
You either want:
=a2-a1
to determine the increase between the first two. Copy this formula down. It
will automatically change to =a3-a2, etc.

Or if you want the total increase, the intermediate values are of no
consequence. Just use:
=a3-a1

Regards,
Fred.

"(e-mail address removed)"
 
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

"(e-mail address removed)"
 
Back
Top