Formulae required
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 |
Formulae required
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 |
Formulae required
Thanks Chip
|
All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com