bomberman411
Board Regular
- Joined
- Oct 23, 2007
- Messages
- 169
Hello, I have some weird problems that I don't know how to fix (or even explain). Mostly, my code is good and works well in all my spreadsheets but I find myself trying to debug stuff that should be working, but isn't working 100% as it should.
For example, I have a cell that counts information using
BTW: NB is COUNT in french, just so you know...
The weird problem is, it seems to skip the first 10-15-20 rows; it doesn't count them. So the total in the cell should be around 150, but it's 129?...
Can someone give me an alternative code to count cells?
For example, I have a cell that counts information using
Code:
=NB($A$8:$A$1000)
The weird problem is, it seems to skip the first 10-15-20 rows; it doesn't count them. So the total in the cell should be around 150, but it's 129?...
Can someone give me an alternative code to count cells?