I have a problem and I need to multiply the three colums individually first
and in the next category I am required to give the total. How do I set uo my
cormula?
Peazhez

"Rick" wrote:

Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 -
C14. In G14 I have put a formula to show the difference between E14 and C14
as a Percentage ( formula for G14 is =SUM(E14-C14)/ABS(E14) ). When the
Formula for G14 looks at E14 and C14 all it sees is a SUM formula to add up
the column. Does anyone know how to solve this problem. Many thanks for
looking. Rick