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

2 ...

Report Post

Posted by MyNameIsInigoMontoya

Woodlands

Member since Oct 2012

585 posts

Posted on 11/11/16 at 3:27 pm to EngineerOnDemand

It's legible...not really intelligible, though. Can you give an example?

1 ...

Report Post

Posted by EngineerOnDemand

Member since Apr 2013

173 posts

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.

0 ...

Report Post

Posted by Spock's Eyebrow

Member since May 2012

12300 posts

Posted on 11/11/16 at 4:47 pm to EngineerOnDemand

Still not sure what you want to do, but does SUMPRODUCT help?

1 ...

Report Post

Posted by lynxcat

Member since Jan 2008

24714 posts

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