Is there a function that counts the number of non-blank cells in a range?

**xibalba** · 07-20-2012, 05:28 PM

**tlafferty** · 07-20-2012, 05:52 PM

Look into count for numbers or counta for text.

**martindwilson** · 07-20-2012, 06:31 PM

black cells? or blank cells?

**xibalba** · 07-21-2012, 03:44 PM

Sorry, meant tos ay "non-blank" cells.

**martindwilson** · 07-21-2012, 06:39 PM

depends on the blank,if it is really blank then counta,if not and the blank is the result of a formula then use sumproduct
see results of col a attached

**xibalba** · 07-23-2012, 12:14 AM

I used countblank and then worked backwords (subtracting the result of countblank from the number of valid colums, and then adding that to the current address to calculate the next) to calculate hex addresses. Had I known of counta, I would've used it instead, since I could just add the result of counta to the current address to calculate the next.

Does countblank work in Excel, as well as Gnumeric (is it cross-platform)? How about counta?

Do they both work with ranges (A1:A10) in Excel?

I think I have everything I need to use spreadsheets to generate an IPS patch. If I can find out more about disc images and the PPF format, then I can generate PPF patches too.