Cell counting and ranges

U

USELESS

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
 
M

Mark Graesser

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
Remove Identical words 0
Copy addition formula of non-consecutive horizontal cells 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Function for summing or counting cells based on a specified fill color 3
Nested if statements creating a blank cell 1
Count Blank Cells with Conditions 3

Top