Sumproduct function
Try this:
=SUMPRODUCT(((A1:A100=F1)+(A1:A100=F2)+(A1:A100=F3 ))*B1:B100)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peter" wrote in message
...
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)+sum
product((--(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
|