| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT
How do I count cells with numbers 1 and greater. My cells are counting the
-. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
By not posting your formula, you don't give us anything to correct.
Try this: For a range of numbers in A1:A100 This formula returns the count of cell values greater than 1: B1: =COUNTIF(A1:A100,"1") Does that help? *********** Regards, Ron XL2002, WinXP "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
hi Christina,
=contif(a2:a1000,"=1") hth regards from Brazil Marcelo "Christina Bachman" escreveu: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
=countif(A1:A100,"0") if numbers can be decimal and less than 1 e.g 0.56
Or =countif(A1:A100,"=1") HTH "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
Hi Christina sory for the typo error =countif(a2:a1000,"=1")
regards "Marcelo" escreveu: hi Christina, =contif(a2:a1000,"=1") hth regards from Brazil Marcelo "Christina Bachman" escreveu: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
OOPs....you wanted 1 inclusive:
=COUNTIF(A1:A100,"=1") Does that help? *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: By not posting your formula, you don't give us anything to correct. Try this: For a range of numbers in A1:A100 This formula returns the count of cell values greater than 1: B1: =COUNTIF(A1:A100,"1") Does that help? *********** Regards, Ron XL2002, WinXP "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11. "Ron Coderre" wrote: OOPs....you wanted 1 inclusive: =COUNTIF(A1:A100,"=1") Does that help? *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: By not posting your formula, you don't give us anything to correct. Try this: For a range of numbers in A1:A100 This formula returns the count of cell values greater than 1: B1: =COUNTIF(A1:A100,"1") Does that help? *********** Regards, Ron XL2002, WinXP "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
Hi Marcelo,
It is close to working but it adding an additional 1, i.e. the count should be 11 but it shows 12. Thanks "Marcelo" wrote: Hi Christina sory for the typo error =countif(a2:a1000,"=1") regards "Marcelo" escreveu: hi Christina, =contif(a2:a1000,"=1") hth regards from Brazil Marcelo "Christina Bachman" escreveu: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11. "Toppers" wrote: =countif(A1:A100,"0") if numbers can be decimal and less than 1 e.g 0.56 Or =countif(A1:A100,"=1") HTH "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
It worked!!!!!! Thank you so much....I had a formula problem.....
"Ron Coderre" wrote: By not posting your formula, you don't give us anything to correct. Try this: For a range of numbers in A1:A100 This formula returns the count of cell values greater than 1: B1: =COUNTIF(A1:A100,"1") Does that help? *********** Regards, Ron XL2002, WinXP "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
It worked!!!!!! Thank you so much...I had a formula problem....
"Marcelo" wrote: hi Christina, =contif(a2:a1000,"=1") hth regards from Brazil Marcelo "Christina Bachman" escreveu: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
MAke sure in the range you are not including the cell that the formula is in
"Christina Bachman" <Christina wrote in message ... How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
Thank you....it worked.....I had a formula problem....
"Toppers" wrote: =countif(A1:A100,"0") if numbers can be decimal and less than 1 e.g 0.56 Or =countif(A1:A100,"=1") HTH "Christina Bachman" wrote: How do I count cells with numbers 1 and greater. My cells are counting the -. All my cells are showing the - (zero value) but are being counted. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Linear Mode
