| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sum the number of times answered in a single column with b.
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:k2230???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sum the number of times answered in a single column withb.
Try this:
=COUNTIF(K7:K223,"0") Hope this helps. Pete On Feb 18, 1:56*am, Steve 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:k2230???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number times a value appears in a column beside it chronological | Excel Worksheet Functions | |||
| Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
| Adding up the number of times a month is in a column | Excel Worksheet Functions | |||
| function for counting how many times a Q is answered wrong | Excel Worksheet Functions | |||
| Count the number of times a name occurs in a column | Excel Worksheet Functions | |||
Linear Mode
