RE: The Secret Power of SUMPRODUCT in Excel

You are viewing a single comment's thread from:

The Secret Power of SUMPRODUCT in Excel

in excel •  6 years ago 

I learned a lot through this video, Paula's an amazing instructor, as always.

As for the activity, the solution is

=SUMPRODUCT(B2:B7;--(CHOOSE(A9;C2:C7;D2:D7;E2:E7)="y"))

excel
6 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.34
  • Past Payouts $0.34
  • - Author $0.25
  • - Curators $0.09
2 votes
2
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  • Trending
    • [-]
      ·  6 years ago 

    I used the CHOOSE function to choose between the bundles, and linked it to the a9 cell, better than writing the formula three times or modifying the formula for each different bundle

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.47
    • Past Payouts $0.47
    • - Author $0.35
    • - Curators $0.12
    3 votes
    [-]
      ·  6 years ago 

    Oh I just noticed I never posted the solution to this. I will have it out in the next week or so, Sorry! Interesting solution you came up with, nice work indeed.

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      1 vote