Learn Excel Episode 177: Who Taught Excel How to Count?
Why does Excel say I have two cells when any seven year old can see it is 9 cells? Because the COUNT function doesn't count like you do. Learn why =COUNT() doesn't always work and the obscure function to work around this problem. Episode 177 will show you how.