- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help
Posted on 11/11/16 at 3:06 pm
Posted on 11/11/16 at 3:06 pm
I have been instructed to minimize using VBA in a spreadsheet, yet I think this may be the only option...
So, I'm trying to multiply and sum a production profile (call it A2:A500) each time B2:B500 is an integer which changes over time. How can I sum these production values whilst still keeping the production profile continuous yet restarting at each new integer?
I hope this request is even legible...
So, I'm trying to multiply and sum a production profile (call it A2:A500) each time B2:B500 is an integer which changes over time. How can I sum these production values whilst still keeping the production profile continuous yet restarting at each new integer?
I hope this request is even legible...
2
Posted on 11/11/16 at 3:27 pm to EngineerOnDemand
It's legible...not really intelligible, though. Can you give an example?
Posted on 11/11/16 at 3:31 pm to MyNameIsInigoMontoya
No problem...
I have a production profile: 100,90,85,70...
Integers are based on time: 0,0,0,1,0,0,8,6...
So, I would like to multiply the production profile by the integer and carry that continuous production profile, while also adding in the additional multiplied production profiles that start later in the sequence.
I have a production profile: 100,90,85,70...
Integers are based on time: 0,0,0,1,0,0,8,6...
So, I would like to multiply the production profile by the integer and carry that continuous production profile, while also adding in the additional multiplied production profiles that start later in the sequence.
Posted on 11/11/16 at 4:47 pm to EngineerOnDemand
Still not sure what you want to do, but does SUMPRODUCT help?
Posted on 11/11/16 at 4:50 pm to Spock's Eyebrow
SUMPRODUCT may be the answer if you want the total of all of those products added into a single cell. Otherwise, why can you just multiply across the production and the integer and get a product in another column? I think that we may need to have a bit more information to get to the answer.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News