How do I use last cell w/value with Sum?
 

I want to subtract the value and only that value from my total and then next
month when I enter a value make it recognize that as the last value and
subtract that?

ie Month 1
$10 $5 = $5

Month 2

$10 $5 $3 =$7

so on and so forth

One way is to use
=INDEX(1:1,MAX(IF(1:1<"",COLUMN(1:1))))

array entered, to return the rightmost entry in row 1.


"TimB1969" wrote in message
...
I want to subtract the value and only that value from my total and then
next
month when I enter a value make it recognize that as the last value and
subtract that?

ie Month 1
$10 $5 = $5

Month 2

$10 $5 $3 =$7

so on and so forth

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

--
Regards
Frank Kabel
Frankfurt, Germany

TimB1969 wrote:
I want to subtract the value and only that value from my total and
then next month when I enter a value make it recognize that as the
last value and subtract that?

ie Month 1
$10 $5 = $5

Month 2

$10 $5 $3 =$7

so on and so forth