Posted to microsoft.public.excel.worksheet.functions
|
|
Multiplying A Range
Thankyou, Exactly what I needed! :-)
--
Dan Walters
"Roger Govier" wrote:
Hi Daniel
Try
=PRODUCT(A1:A10)
--
Regards
Roger Govier
"DanielWalters6" wrote in
message ...
Assume I have from A1:A10 these values;
1,3,4,5,6,7,4,2,2,6
If I multiply these together, i get 241920
If I sum(a1:a10)*10 then it gives me 400.
Quite a different answer.
Thankyou foryour help allthe same
--
Dan Walters
"Don Guillett" wrote:
?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software
"DanielWalters6" wrote in
message
...
Is there a function, like
=Fact(10)
Which multiplies all the values in a particular range?
=FUNCTIONNAME(A1:A10)
if not, can you suggest a way to do this in VBA?
Dan Walters
|