Brecht
Member
- Joined
- Sep 15, 2014
- Messages
- 36
- Reaction score
- 0
- Points
- 6
- Location
- Netherlands
- Excel Version(s)
- Version 2007
Hi all
I have an excel table that looks like this
(Letters are column letters; 1) etc are row numbers)
What I want is a formula that lets me know the range of cells that are larger than 0 .
So I'd get
1) = 3
2) = 4
3) = 3
4) = 5
5) = 4 (despite the 0 in the middle)
7) = 4
8) = 1
Can anyone help me out with this?
Much appreciated!
I have an excel table that looks like this
| B | C | D | E | F | |
| 1) | 0 | 11 | 4 | 1 | 0 |
| 2) | 0 | 2 | 5 | 9 | 1 |
| 3) | 3 | 4 | 9 | 0 | 0 |
| 4) | 2 | 6 | 3 | 5 | 3 |
| 5) | 8 | 7 | 0 | 1 | 0 |
| 6) | 4 | 6 | 5 | 1 | 0 |
| 7) | 10 | 3 | 2 | 1 | 0 |
| 8) | 0 | 0 | 0 | 16 | 0 |
(Letters are column letters; 1) etc are row numbers)
What I want is a formula that lets me know the range of cells that are larger than 0 .
So I'd get
1) = 3
2) = 4
3) = 3
4) = 5
5) = 4 (despite the 0 in the middle)
7) = 4
8) = 1
Can anyone help me out with this?
Much appreciated!
