Counting days and Configurations together
 

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

Look at pivot tables (if you must!).

--
HTH

-------

Bob Phillips
"Kevin M" wrote in message
...
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

I said better way :)

Kevin M
-----Original Message-----
Look at pivot tables (if you must!).

--
HTH

-------

Bob Phillips
"Kevin M"
wrote in message
...
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


.