SUMPRODUCT help

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

May I say a collective Thank You to Frank, Domenic, Peo,
Harlan and Aladin.

I was able to use your advice and good ideas, and got a
solution that worked. Thanks for responding.

One related question please. If the code range is 210 to
214 and also 619 to 656, how can I show those without
having to type in all those digits? Much appreciate any
help.
 
Hi Randy
try
=SUMPRODUCT(--(CodeRange>=210),--(CodeRange<=214),RangeToSum)+SUMPRODUC
T(--(CodeRange>=619),--(CodeRange<=656),RangeToSum)
 
Put the numbers in an unused worksheet
=SUMPRODUCT(--ISNUMBER(MATCH(CodeRange,Sheet2!A1:A37,0)),RangeToSum)
Use autofill to put numbers without having to type them all on Sheet2
 
Thanks.
-----Original Message-----
Put the numbers in an unused worksheet
=SUMPRODUCT(--ISNUMBER(MATCH(CodeRange,Sheet2! A1:A37,0)),RangeToSum)
Use autofill to put numbers without having to type them all on Sheet2
Click to expand...
 
Back
Top