SUMPRODUCT Based on WBS

Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Aug 26, 2019 at 09:53 AM
See more 

4 replies

Best answer
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571
1
Thank you
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.


Say "Thank you" 1

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 5626 users have said thank you to us this month

Respond to ac3mark
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1
1
Thank you
" Are you trying to calculate a whole number, as in 100% of something?"....Yes Exactly

Say "Thank you" 1

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 5626 users have said thank you to us this month

Respond to Ebti59
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571
1
Thank you
Then it is just sum.

Say "Thank you" 1

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 5626 users have said thank you to us this month

Respond to ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571
0
Thank you
Which part do you have a trouble with?

You have provided no details, again!!!!
Ebti59
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1 -
Defining SUMPRODUCT for Top level .
Thanks again
Ebti59
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1 -
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
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571 -
No, it didnt help. Still makes no sense.

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