Dear all,
Please see below sample data and the output that I need to.
2001 2002 2003
Sales £51,840.00 £62,208.00 £74,649.60
Unit Costs 23,152.50 24,310.13 25,525.63
Fixed Costs 2,500.00 2,500.00 2,500.00
Gross Profit 26,187.50 35,397.88 46,623.97
Tax 13,093.75 17,698.94 23,311.98
What excel function can I use in order for me to give the output below?
Base on the data above, output would be:
Sales Unit Cost Fixed cost Gross Tax
2002 62,208.00 24,310.13 2,500.00 35,397.88 17,698.94
Sorry its hard to explain.I also attached excel file to clear to understand.
Thanks.
garacious
Bookmarks