sfaheather84
New member
- Joined
- Jun 13, 2019
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365 MOS
Example file attached. I am trying to count the number customers in 2017 that total for 2016+2017 fall into the threasholds in A26 to A32 (greater than or equal to the amount, but less than value above) without adding a helper column.
For example, at the 80k level, the formula would return three customers as customer I-K totals are >= 80k, but < 100k.
The full result would be
100k - 5
80k - 3
50k -8
36k - 0
25k - 0
12.5k - 0
1 - 1
For example, at the 80k level, the formula would return three customers as customer I-K totals are >= 80k, but < 100k.
The full result would be
100k - 5
80k - 3
50k -8
36k - 0
25k - 0
12.5k - 0
1 - 1