We help IT Professionals succeed at work.

# Sum Required

on
Hi,

In the attached spreadsheet shows cells C28 to I28 representing how much sales have gone up or down.  Now in cell c5 I would like a sum which takes my sales figure for this years april ie 500 (B4) and uses last years percentage to show me if i repeat the percentage what me sales figure would now be.

Kind Regards
Simon
Book1.xls
Comment
Watch Question

## View Solution Only

CERTIFIED EXPERT
Commented:
I think what you're asking for could be done by using this formula in C5.

=(C28 + 1) * B4
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

try in C5

=B4+(C28*B4)

Do you want this formula refers to the actual sales data of the last month, so if no actual data has been entered yet, it will show 0

cheers, teylyn
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
If you want to project the same sales differences for the whole period, you can use this in C6

=C5+(D28*C5)

copy right. This will show data even if no actual sales have been entered in row 4. Note that C5 and C6 are different formulas.

cheers,

Commented:
Is that percentage an increase over the value in B4, or is it a difference?  I mean, does 50% equate to \$750, or does it equate to \$250?

If it's a straight difference, then the formula for C4 would be:
=\$B4*C28
and you would just copy that formula into the adjacent cells.

If it's an increase over B4, it'd be:
=\$B4+\$B4*C28

If it's a difference or increase from the previous month, you would remove the "\$" before the B.

Commented:
Great Thanks!
CERTIFIED EXPERT

Commented:
Looks like I was just in time!