Counting days and Configurations together

[Kevin M]

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

 

[Bob Phillips]

Look at pivot tables (if you must!).

 

[Guest]

I said better way

Kevin M

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

--
HTH

-------

Bob Phillips



.