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" <kmcclement@NOSPAM.precisiondrilling.com> wrote in message
news:141d01c4f354$eaa7bb80$a501280a@phx.gbl...
> 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" <kmcclement@NOSPAM.precisiondrilling.com>
wrote in message
>news:141d01c4f354$eaa7bb80$a501280a@phx.gbl...
>> 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
>
>
>.
>