Stuck on a anlysis formula 2

  • Thread starter Thread starter Allierz
  • Start date Start date
A

Allierz

Sorry guys. This all a bit new to me. Should have included all details
Trust this a lot clearer

I have 6 cells

A1 Customers Name
B1 Customers Logo
C1 Sales Jan - Dec 2001
D1 Sales Jan - Dec 2002
E1 Sales Jan - Dec 2003
F1 Sales YTD Lan - April 2004
G1 $ Difference 2002 - 2003
H1 % Difference 2002 - 2003
Cells A1 to E1 are entered manually
Cell F1 has a formula: =D2-C2
Cell G1 has a formula: =D2/C2-100%

I need to add another column to arrive a comparison of sales YTD i
Cell F1 and compare this to the figure in Cell D2 but for the sam
period. Firgure in D2 is for 12 months, not 4 months. The answer I a
looking for is the % of diferrence be that + or -.

The slaes sheets are spilt into Areas or Reps so they vary in ht
amount of customers and are totalled at the bottom.

The other problem that I see is do I need to alter the formula ever
month or can a formula be based on a date? The above is for figures a
the end of April. What happens in May?

Trust this is clearer.

Many thanks for your help.

Alli
 
Not to clear to me- if I lay out the cells as described below, I get lost - Sorr
SamsClub Logo 1000 1500 2000 1000 1000 67
Cust Logo 12/31/01 12/31/02 12/31/03 4/30/2002 2003-2002 %2002-200
A1 Customers Name
B1 Customers Logo
C1 Sales Jan - Dec 2001
D1 Sales Jan - Dec 2002
E1 Sales Jan - Dec 2003
F1 Sales YTD Lan - April 2004
G1 $ Difference 2002 - 2003
H1 % Difference 2002 - 2003
Cells A1 to E1 are entered manually
Cell F1 has a formula: =D2-C2
Cell G1 has a formula: =D2/C2-100%
 
Back
Top