I have an excel workbook where I need to add a formula that adds Size Cost
and Amount together. I work in reprographics and the sheet adds up variuos
types of prints against a cost and number of copies. I tried to use an IF
formula but there are too many variables. If you can imagine there are A4
B/W A3 B/W A4 Colour A3 Colour etc. I have set a number against these to make
it easier to track e.g. A4 B/W =1 A3 B/W = 12 A4 Colour = 2 A3 Colour = 22.
THen I need to track these against cost and number of prints. Can anyone help
me as it is driving me crazy.

Thank you in advance

P.S. Is it possible to load the sheet to show what I mean?