Need formula for a fixed cell minus last entry on ongoing log

M

Mari C

Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari
 
K

Kassie

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.
 
M

Mari C

Thanks biff - after I limited the size of the column I was able to enter it
in the bottom of the column
Mari
 
M

Mari C

Hi Kassie

I needed to enter 20 columns so I wanted the sum at the bottom of the column
- biffs formula worked better for the layout of the page but yours was great
too. thanks a bunch
 
B

Biff

You're welcome. Thanks for the feedback!

Biff

Mari C said:
Thanks biff - after I limited the size of the column I was able to enter
it
in the bottom of the column
Mari
Click to expand...
 
Top