SUMPRODUCT Based on WBS

Closed
Ebti59 Posts 5 Registration date Tuesday August 20, 2019 Status Member Last seen August 26, 2019 - Aug 23, 2019 at 10:00 AM
 Blocked Profile - Aug 26, 2019 at 09:53 AM

4 replies

Sumproduct is used to Mulitply 2 columns, then add them, as in this example.

So here is the product of the first "level1" request, using SUMPRODUCT. Perhaps SUM would do it if you are trying to determine a whole product of 1, or 100%.


Here is SUM.


1
Ebti59 Posts 5 Registration date Tuesday August 20, 2019 Status Member Last seen August 26, 2019 1
Aug 26, 2019 at 09:43 AM
" Are you trying to calculate a whole number, as in 100% of something?"....Yes Exactly
1
Blocked Profile
Aug 26, 2019 at 09:53 AM
Then it is just sum.
1
Blocked Profile
Aug 23, 2019 at 04:56 PM
Which part do you have a trouble with?

You have provided no details, again!!!!
0
Ebti59 Posts 5 Registration date Tuesday August 20, 2019 Status Member Last seen August 26, 2019 1
Aug 23, 2019 at 11:03 PM
Defining SUMPRODUCT for Top level .
Thanks again
0
Ebti59 Posts 5 Registration date Tuesday August 20, 2019 Status Member Last seen August 26, 2019 1
Aug 25, 2019 at 11:33 PM
Hello,
I know "Sumproduct is used to Mulitply 2"
the screenshot shows a part of work break down,the main WBS has 3892 task in level 6, I am trying at first SUMPRODUCT each level 6 in its total level(5) then each level 5 to its total..finally SUMPRODUCT all levels 2 in level 1...my problem is I want to do this for more than 3982 task in various level and it takes time ...
I hope my explain will be helpful .
thanks again
0
No, it didnt help. Still makes no sense.

Are you trying to calculate a whole number, as in 100% of something?
0