Sum Rewards by Validator
I need to sum 'Staking Rewards' where Validator is 'Coinbase' and Asset is 'ATOM'.
=SUMIFS(D2:D10, B2:B10, "Coinbase", C2:C10, "ATOM") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria simultaneously. In this scenario, it efficiently filters the staking rewards data to only include entries where the validator is 'Coinbase' AND the asset is 'ATOM', providing a precise total for specific reward streams, crucial for performance tracking and reporting.
Data Setup
| Date | Validator | Asset | Staking Rewards (USD) |
|---|---|---|---|
| 2023-01-01 | Coinbase | ATOM | 15.25 |
| 2023-01-01 | Binance | ETH | 10.50 |
| 2023-01-02 | Coinbase | ATOM | 12.75 |
| 2023-01-02 | Kraken | SOL | 8.00 |
| 2023-01-03 | Coinbase | ETH | 5.00 |
| 2023-01-03 | Binance | ATOM | 7.20 |
| 2023-01-04 | Coinbase | ATOM | 20.00 |
| 2023-01-04 | Kraken | ATOM | 6.50 |
| 2023-01-05 | Coinbase | DOT | 3.00 |
Step-by-Step Guide
Identify the range containing the values you want to sum (Staking Rewards), which is D2:D10.
Specify the first criteria range (Validator) as B2:B10 and its corresponding criteria ('Coinbase').
Specify the second criteria range (Asset) as C2:C10 and its corresponding criteria ('ATOM').
Combine these into the SUMIFS function: =SUMIFS(D2:D10, B2:B10, "Coinbase", C2:C10, "ATOM").