Greetings,

Problem:

Need to calculate membership totals in columns "C thru G" to find out
the growth or decline of membership in the last 5 yrs.
1848 1717 1702 1472 1369

I want the outcome to show up as a positive or negative number in
column "I"
(My column "H" is an AVG formula cell.)

Can someone send me something I can paste in myself?

I need this today!

Blessings,
SLR
:)


--
slr
------------------------------------------------------------------------
slr's Profile: http://www.excelforum.com/member.php...o&userid=25609
View this thread: http://www.excelforum.com/showthread...hreadid=390227

Does the forumula c1-g1 do what you want? Basically it just calculates
the total change in membership. A negative result indicates a
decrease, a positive result indicates an increase.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=390227

Thanks for your quick respone Mr. Shorty.

The totals in cells c1 thru g1 are just membership totals (numbers) for
each yr.

What I need to do is create an "H1" cell that tells me if we increased
or decreased in membership from the first yr to the last yr. and,
maybe in the same cell, by how much.

Is this something simple that you can help me with?

Can you design something so that I can zap it in?
SLR


--
slr
------------------------------------------------------------------------
slr's Profile: http://www.excelforum.com/member.php...o&userid=25609
View this thread: http://www.excelforum.com/showthread...hreadid=390227

Can you not simply take the difference of the 1st and last years'
numbers as I suggested?

PS I note that I got the order of the subtraction wrong for what I was
intending. Should G1-C1 (lastyear-firstyear).


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=390227

Basically, the example below will show you what I have:

c1 d1 e1 f1 g1

1,848 1,717 1,702 1,472 1,369


I want to create a result in "I1" to tell me if the membership for 5
yrs. is a increase or decline. I guess you would compute each yr. to
the 1st until you end up with an overall increase or decrease --I don't
really know.

I just want a formula in "I1" to say memberships increased or decreased
over the past 5 yrs, and by how much.

Blessings,
SLR


--
slr
------------------------------------------------------------------------
slr's Profile: http://www.excelforum.com/member.php...o&userid=25609
View this thread: http://www.excelforum.com/showthread...hreadid=390227

You've given two "goals" for your formula. I'm not sure what it is
about the formula =g1-c1 that isn't good enough. Your goals and how
this formula acheives those goals:

1) Is membership for last year an increase or decrease from 1st years
membership? Indicated by the sign of the result. A negative result
indicates a decrease in membership and a positive result indicates an
increase in membership.

2) How much of an increase or decrease? The value returned indicates
how many more or fewer members.

Are there more requirements that I'm missing?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=390227