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
Blocked Profile - Aug 26, 2019 at 09:53 AM
Related:
- We couldn't find an account that matches what you entered but found one that closely matches
- Wbs download - Download - Organisation and teamwork
- Based on the values in cells b77 b81 c77 - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 ✓ - Excel Forum
4 responses
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.
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.
Ebti59
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1
Aug 26, 2019 at 09:43 AM
Aug 26, 2019 at 09:43 AM
" Are you trying to calculate a whole number, as in 100% of something?"....Yes Exactly
Which part do you have a trouble with?
You have provided no details, again!!!!
You have provided no details, again!!!!
Ebti59
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1
Aug 23, 2019 at 11:03 PM
Aug 23, 2019 at 11:03 PM
Defining SUMPRODUCT for Top level .
Thanks again
Thanks again
Ebti59
Posts
5
Registration date
Tuesday August 20, 2019
Status
Member
Last seen
August 26, 2019
1
Aug 25, 2019 at 11:33 PM
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
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
