Help with Excel formulas - example attached

  • Thread starter Thread starter aly1cat
  • Start date Start date
A

aly1cat

I have created pivot tables for monthly sales figures, however i want t
create a formula that will insert the figure for jan and consecutiv
months in the month boxes on sheet 6 for each country and so on. The
I want to be able to create a formula to how well each country eac
performing month on month against there individual targets as
percentage and as a figure.

Can anyone help please

Attachment filename: pots update weekending (temp).xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42190
 
It is not apparent from the example what the amounts are for the countries.
Not knowing how this is set up, it is difficult to advise.
 
Back
Top