You are viewing a single comment's thread from:

RE: The Secret Power of SUMPRODUCT in Excel

in #excel5 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

Sort:  

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.

Coin Marketplace

STEEM 0.17
TRX 0.15
JST 0.028
BTC 56775.06
ETH 2345.64
USDT 1.00
SBD 2.36