Context
- Entry Price (a.k.a.
Formula in
C2:=SUMPRODUCT(INDEX([Entry Price],1):[@[Entry Price]],INDEX([Quantity (BTC)],1):[@[Quantity (BTC)]])/SUM(INDEX([Quantity (BTC)],1):[@[Quantity (BTC)]])This will now autopopulate upon new entries:
Formula in C2:
=SUMPRODUCT(INDEX([Entry Price],1):[@[Entry Price]],INDEX([Quantity (BTC)],1):[@[Quantity (BTC)]])/SUM(INDEX([Quantity (BTC)],1):[@[Quantity (BTC)]])
This will now autopopulate upon new entries: