| Home |
| Search |
| Today's Posts |
|
#5
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
Threaded Mode
