Cell counting and ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i count cells between a range, cells may have values or may be blank, i want to exclude cells with formulas in them, plus the range must be able to specify itself. e.g Count from cell marked S to cell mark T, Include blanks and exclude formulas
 
USELESS
The following formula will give you the number of cells between S and T in column A

=MATCH("T",A:A,0)-MATCH("S",A:A,0)-

I don't know about identifying cells with formulas. The help files on the TYPE function used
to say it would return an 8 for a formula, but it never worked. I am using Excel 97, but I believe MS removed the formula reference from the help files in later versions

Good Luck
Mark Graesse
(e-mail address removed)

----- USELESS wrote: ----

How do i count cells between a range, cells may have values or may be blank, i want to exclude cells with formulas in them, plus the range must be able to specify itself. e.g Count from cell marked S to cell mark T, Include blanks and exclude formulas
 
Back
Top