Hive

Comments

aloverapy (37)in #excel • 5 years ago
RE: The Secret Power of SUMPRODUCT in Excel
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
$0.48
Past Payouts $0.48
- Author $0.36
- Curators & beneficiaries $0.12
> steempress: $0.01
3 1
aloverapy (37)in #excel • 5 years ago
RE: The Secret Power of SUMPRODUCT in Excel
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"))
$0.35
Past Payouts $0.35
- Author $0.26
- Curators & beneficiaries $0.09
> steempress: $0.01
2 2