Re:Stop Using Excel, Finance Chiefs Tell Staffs
by ZenoArrow on Wednesday November 22, 2017 @12:40PM
(#15758706)
For example if you have to sum a columns of numbers and one of them was mistakenly input as text, rather than throwing an error, it will just ignore that entry.
There are ways around that. Here's something I just put together as an example:
=EXACT(COUNT(A2:A6),COUNTA(A2:A6))
That will only return true if all the cells in range A2:A6 contain numbers.
There are other approaches that would work, if that doesn't suit you.
There are ways around that. Here's something I just put together as an example:
=EXACT(COUNT(A2:A6),COUNTA(A2:A6))
That will only return true if all the cells in range A2:A6 contain numbers.
There are other approaches that would work, if that doesn't suit you.