Re: excel and counting cells


Charles Coe
 

Use the following formula example:
=count(b1:b25,"*")

This will inform you the total number of cells that have numbers in them.

Hope this is of help.

Charles

-----Original Message-----
From: Jfw [mailto:jfw-bounces@lists.the-jdh.com] On Behalf Of stintonjoe---
via Jfw
Sent: Wednesday, October 22, 2014 9:42 AM
To: jaws users
Subject: excel and counting cells

Hi all in micro soft excel I have collems with lots of numbers in but also
lots of gaps so for example i might have in the b collem numbers in cells
b23 b24 b25 then a gap untill b56 b57 etc. so can i have a formula which
will count how many cells have numbers in the row? and if so what is the
formula ?
i have windows 7 and jaws 12

thanks in advance Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201410
22/54ef1aa3/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Join main@jfw.groups.io to automatically receive all group messages.