| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
I see a lot of posts here to do with sumproduct and I know how it works
(multiplying corresponding data in arrays and then summing the results) but what practical applications does it have. What situations would best be taken advantage of by using sumproduct? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT
Mark McDonough wrote: I see a lot of posts here to do with sumproduct and I know how it works (multiplying corresponding data in arrays and then summing the results) but what practical applications does it have. What situations would best be taken advantage of by using sumproduct? Hi, Have a look at this article about counting and summing in Excel: http://www.microsoft.com/office/prev...s/column10.asp Regards, Bondi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
