Forum Discussion
Count donors who's total giving is within a specific range
Hello, I need to count donors who's total giving is within a list of ranges. The issues I have is: 1) there is one row per gift and some donors made multiple gifts so I need to calculate the total value first 2) is it worth having the resulting total checked against a range to simplify the formula in the final table? I will eventually need to include the additional critera of the year, since we want to do this calculation for the past six years. Thanks.
| Data | Range of gifts $ | ||||
| Donor | Gift | Year | Minimum | Maximum | |
| Smith | $1,000.00 | 2021 | $0.00 | $99.00 | |
| Jones | $250.00 | 2021 | $100.00 | $999.00 | |
| Allen | $15.00 | 2021 | $1,000.00 | $9,999.00 | |
| Jones | $250.00 | 2021 | $10,000.00 | $99,999.00 | |
| Smith | $500.00 | 2021 | $100,000.00 | $999,999.00 | |
| Smith | $40,000.00 | 2021 | $1,000,000.00 | $9,999,999.00 | |
| Roberts | $75.00 | 2021 | |||
| Boucher | $250.00 | 2020 | |||
| Brothers | $20.00 | 2021 | |||
Report on Number of Donors | |||||
| Range | 2021 | 2020 | |||
| 0 to 99 | |||||
| 100 to 999 | |||||
| 1000 to 9999 | |||||
| 10000 to 99999 | |||||
| 100000 to 999999 | |||||
| 1000000 to 9999999 |
1 Reply
I attach the file here.
