How to sum the number of times answered in a single column with b.

S

Steve

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????
 

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

Sum of values in column A based on 0/1 of column B 2
How to count the number of times a number is repeated in a column 2
Function in Excel to count and list number of entries of text valuesin a row. 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
number times a value appears in a column beside it chronological 3
Sum the amount of times a number appears in a column in Excel? 2
Code to Resize a variable number of rows including target 7
How to find a column number using variable criteria? 2

Top