Count Votes for Proposal
As a DAO Treasurer, I need to count how many 'Yes' votes a proposal received, specifically from members whose 'Token Balance' is greater than 1000. This helps in understanding the weighted support for a proposal.
=COUNTIFS(B2:B8,"Yes",C2:C8,">1000") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this scenario, it first checks column B for 'Yes' votes. For every row that has 'Yes' in column B, it then checks if the corresponding 'Token Balance' in column C is greater than 1000. Only rows that satisfy *both* conditions are included in the final count, providing a precise measure of weighted 'Yes' votes.
Data Setup
| Voter | Vote | Token Balance |
|---|---|---|
| Alice | Yes | 1500 |
| Bob | No | 2000 |
| Charlie | Yes | 800 |
| David | Yes | 1200 |
| Eve | No | 500 |
| Frank | Yes | 1001 |
| Grace | Yes | 999 |
Step-by-Step Guide
Identify the range containing the 'Vote' status (e.g., 'Yes', 'No'). In our mock data, this is column B (B2:B8).
Identify the range containing the 'Token Balance'. In our mock data, this is column C (C2:C8).
Enter the COUNTIFS function. The first criterion range is B2:B8, and the criterion is "Yes".
The second criterion range is C2:C8, and the criterion is ">1000".
The complete formula will be =COUNTIFS(B2:B8,"Yes",C2:C8,">1000"). Press Enter to get the result.