Related:
- Sumproduct based on wbs
- Sumproduct based on relative cell ✓ - Forum - Excel
- Excel conditional formatting based on date in another cell - How-To - Excel
- Excel macro to create new sheet based on value in cells - How-To - Excel
- Excel move row to another sheet based on cell value - Forum - Excel
- Wbs chart pro - Download - File management
4 replies
Best answer
- Posts
- 12936
- Registration date
- Monday June 3, 2013
- Status
- Moderator
- Last seen
- September 3, 2019
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.
Glad we were able to help! Love us? Write us a review! Rate CCM
6897 users have said thank you to us this month
" Are you trying to calculate a whole number, as in 100% of something?"....Yes Exactly
Glad we were able to help! Love us? Write us a review! Rate CCM
6897 users have said thank you to us this month
- Posts
- 12936
- Registration date
- Monday June 3, 2013
- Status
- Moderator
- Last seen
- September 3, 2019
Then it is just sum.
Glad we were able to help! Love us? Write us a review! Rate CCM
6897 users have said thank you to us this month
- Posts
- 5
- Registration date
- Tuesday August 20, 2019
- Status
- Member
- Last seen
- August 26, 2019
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
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD