SUMPRODUCT help

[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.

 

[Frank Kabel]

Hi Randy
try
=SUMPRODUCT(--(CodeRange>=210),--(CodeRange<=214),RangeToSum)+SUMPRODUC
T(--(CodeRange>=619),--(CodeRange<=656),RangeToSum)

 

[Bernard Liengme]

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

 

[Randy]

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

 

[Guest]

Thank you.