Can anyone help I have rows A B C and D in row E i want the product i.e. A x
B x C x D cvalculated and row F i want the addition of A + B +C + D
calulated
Can that be done in excel and what formulae do i use?

Thank you in advance

Roy,

In cell E1, use the formula =PRODUCT(A1:D1)
In cell F1, use the formula =SUM(A1:D1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Roy" wrote in message
...
Can anyone help I have rows A B C and D in row E i want the
product i.e. A x
B x C x D cvalculated and row F i want the addition of A + B
+C + D
calulated
Can that be done in excel and what formulae do i use?

Thank you in advance

Thanks Chip