Hello all, Happy New Year and TIA..

I have a list of days in Col A and a list of Motor
Configurations in B, both user entered. There are a total
of 9 Motor Configs and of course, 31 days in a month at
most. I need to pull and sum up each combination so:
A B
02 340
02 340
02 475
02 625
03 375
03 800
03 650
04 475

and so on. I just don't want to run into using a
sumproduct for EVERY day of the year for all 9 motor
configs. The calculations will take forever. I'm assuming
there's a better way :-)

Thanks,

Kevin M