Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|