SUMPRODUCT Based on WBS [Closed]

Report
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
-
 Blocked Profile -

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


Then it is just sum.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


Which part do you have a trouble with?

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

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