Prev: how do I create a formula to add up time on a time sheet
Next: where is tthe "read only" TOGGLE button ?
From: Steve on 17 Feb 2010 20:56
I have a column of data with number answers and blanks. The numbers vary
slightly between 9 to 11, with no answers or zero's for some rows. I only
want to know the number of times in the column that an anwer is present out
of 214 rows. I thought the "DCOUNTA" function was right, but I just can't
get it. It ranges from K6 with the lablel "Corners" to K223 for 214 rows of
Condos and info on room counts and sizes. I don't seem to have the criteria
statement right. It thought it would be K7:k223>0????
From: Pete_UK on 17 Feb 2010 21:15
Try this:

=COUNTIF(K7:K223,">0")

Hope this helps.

Pete

On Feb 18, 1:56 am, Steve <St...(a)discussions.microsoft.com> wrote:
> I have a column of data with number answers and blanks. The numbers vary
> slightly between 9 to 11, with no answers or zero's for some rows. I only
> want to know the number of times in the column that an anwer is present out
> of 214 rows.  I thought the "DCOUNTA" function was right, but I just can't
> get it.  It ranges from K6 with the lablel "Corners" to K223 for 214 rows of
> Condos and info on room counts and sizes. I don't seem to have the criteria
> statement right.  It thought it would be  K7:k223>0????

 | 
Pages: 1
Prev: how do I create a formula to add up time on a time sheet
Next: where is tthe "read only" TOGGLE button ?