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