Blanks counted when highlighting group of cells
When I highlight a group of cells that include values and blanks, the "count"
function that shows up at the bottom of the screen counts the blanks as well as the values. I know if I use "text to cloumns" on the column, it will clear out the blanks, but is there a faster way? I have alot of columns and I'd hate to have to do "text to column" on each one. I only want to count the values in each column. -- mm |
Blanks counted when highlighting group of cells
mm,
Use COUNTA instead of COUNT. COUNTA only looks at cells that are not empty. "marchettimama" wrote: When I highlight a group of cells that include values and blanks, the "count" function that shows up at the bottom of the screen counts the blanks as well as the values. I know if I use "text to cloumns" on the column, it will clear out the blanks, but is there a faster way? I have alot of columns and I'd hate to have to do "text to column" on each one. I only want to count the values in each column. -- mm |
Blanks counted when highlighting group of cells
An alternative to try it as-is, something like this in B2:
=SUMPRODUCT(--(A2:A10<"")) The expression will count only the non blank cells ie it'll exclude real blank cells and cells with "" (zero length null strings) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "marchettimama" wrote: When I highlight a group of cells that include values and blanks, the "count" function that shows up at the bottom of the screen counts the blanks as well as the values. I know if I use "text to cloumns" on the column, it will clear out the blanks, but is there a faster way? I have alot of columns and I'd hate to have to do "text to column" on each one. I only want to count the values in each column. -- mm |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com