| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help summing product of two arrays
Can anyone show me a formula to sum a product of two arrays only when there
is a match. Suppose I want to add up the product of A and C for Apple (answer 3%) and Orange (answer 3.5%) eg. A B C 1% Apple 100% 2% Orange 50% 3% Pear 25% 4% Apple 50% 5% Orange 50% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summed product of multiple arrays | Excel Worksheet Functions | |||
| Summing inventory by quarter and product# | Excel Worksheet Functions | |||
| Product of 2 arrays based on criteria | Excel Discussion (Misc queries) | |||
| Summing Arrays | Excel Worksheet Functions | |||
| summing an array by product category | Excel Worksheet Functions | |||
Threaded Mode
