Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Array Range & Individual Cells
Hello,
If I do a regular array, I would do something like: {=SUM(A1:A5*B1:B5)} to multiple a1*b1 + a2*b2, etc. However, can i have a range like A1:A5, but then select individual cells to multiply by? For example, {=SUM(A1:A5*D1,F5,G6,H8,I9)} where a1*d1 + a2*f5 + a3*g6, etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Array Range & Individual Cells
This is limited to 29 cells but works:
=SUMPRODUCT(A1:A5,CHOOSE({1;2;3;4;5},D1,F5,G6,H8,I 9)) -- Biff Microsoft Excel MVP "Native" wrote in message ... Hello, If I do a regular array, I would do something like: {=SUM(A1:A5*B1:B5)} to multiple a1*b1 + a2*b2, etc. However, can i have a range like A1:A5, but then select individual cells to multiply by? For example, {=SUM(A1:A5*D1,F5,G6,H8,I9)} where a1*d1 + a2*f5 + a3*g6, etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Redefine range of cells, array formula returns NA | Excel Discussion (Misc queries) | |||
Individual cell selection in a range | Excel Discussion (Misc queries) | |||
How to get individual dates from a date range | Excel Discussion (Misc queries) | |||
Excel should lock individual cells or range only | Excel Worksheet Functions | |||
Convert Data Range in to individual values | Excel Discussion (Misc queries) |