Formulae required

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

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
 
Back
Top