Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct function
Do you know how to include a 'is one of' argument to a sumproduct function?
For example if I have a list of codes in the range 0001 to 9999 in column A1 to A100 and the (say) $ amounts in B1 to B100 and the values I wish to select in cells F1, F2 and F3. I current have to write =(sumproduct(--(a1:a100=F1),b1.b100)+sumproduct((--(a1:a100=F2),b1.b100)+sumproduct((--(a1:a100=F3),b1.b100)). I am sure there is an easier way to the include the F1, F2 & F3 in one single sumproduct formula. Any ideas? Many thanks -- Peter London, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
Skipping cells when using SUMPRODUCT function | Excel Discussion (Misc queries) | |||
use of sumproduct function | Excel Worksheet Functions | |||
Sumproduct function | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |