You are viewing a single comment's thread from:

RE: The Secret Power of SUMPRODUCT in Excel

in #excel • 5 years ago

Well Paula that was a very challenging activity I must say. I would really encourage others to try it out as working out the formula really made the penny drop on how sumproduct works in terms of trues and falses and 1 and 0.

Looking at bundle 1, the answer should 94. I finally achieved that result with the formula =SUMPRODUCT(--(C2:C7="Y"),$B$2:$B$7)

Im looking forward to the solution.

5 years ago in #excel by
$0.29
  • Past Payouts $0.29, 0.00 TRX
  • - Author $0.23, 0.00 TRX
  • - Curators $0.06, 0.00 TRX
6 votes
Reply 1
Sort:  
  • Trending
    • [-]
     5 years ago 

    Dernan I should have known you would be the first in here to solve this, you will have to wait now till next week when I publish the solutions to find out if you are right

    $0.00
      Reply

      Coin Marketplace

      STEEM 0.13
      TRX 0.12
      JST 0.024
      BTC 49842.52
      ETH 2229.37
      USDT 1.00
      SBD 2.00