Formula needed for counting

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
 
T

T. Valko

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)"
 
F

Fred Smith

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)"
 
A

Ashish Mathur

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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
vlookup or some other function that counts rows 0
Countif or other formula needed for multiple data/critera results 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Count blanks by date 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
Counting results of a formula 9
Help with a formula for a Time Sheet. 1

Top