| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cells with positive numbers
In a row of 20 cells from A1:T1, how can I count the number of cells that
are greater than 0? Thanks for your help. Jamie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells with positive numbers
=COUNTIF(A1:T1,"0")
-- Gary's Student "Jamie" wrote: In a row of 20 cells from A1:T1, how can I count the number of cells that are greater than 0? Thanks for your help. Jamie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells with positive numbers
Try =COUNTIF(A1:T1,"0")
HTH Regards, Howard "Jamie" wrote in message ... In a row of 20 cells from A1:T1, how can I count the number of cells that are greater than 0? Thanks for your help. Jamie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells with positive numbers
My thanks to Gary"s Student and L. Howard Kittle.
One question though, by putting the quotation marks around 0, doesn't that change it into a text? I thought Excel can understand numeric argument. "Jamie" wrote in message ... In a row of 20 cells from A1:T1, how can I count the number of cells that are greater than 0? Thanks for your help. Jamie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells with positive numbers
Hi Jamie,
COUNTIF is a bit bountiful with the " "'s and without. I keep a list of about 20 different formula's of COUNTIF to keep me straight. Some examples using Data, a named range, as the Range. =Countif(Data,12) the number of cells containing the value 12 =Countif(Data,A1) the number of cells equal to the contents of A1. =Countif(Data,TODAY()) the number of cells containing current date =Countif(Data,TRUE) the number of cells containing logical true. =Countif(Data,"*") the number of cells containing text. =Countif(Data,"???") the number of cells containing exactly 3 characters. HTH Regards, Howard "Jamie" wrote in message ... My thanks to Gary"s Student and L. Howard Kittle. One question though, by putting the quotation marks around 0, doesn't that change it into a text? I thought Excel can understand numeric argument. "Jamie" wrote in message ... In a row of 20 cells from A1:T1, how can I count the number of cells that are greater than 0? Thanks for your help. Jamie |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells with positive numbers
Thanks again. Those are worth knowing.
"L. Howard Kittle" wrote in message . .. Hi Jamie, COUNTIF is a bit bountiful with the " "'s and without. I keep a list of about 20 different formula's of COUNTIF to keep me straight. Some examples using Data, a named range, as the Range. =Countif(Data,12) the number of cells containing the value 12 =Countif(Data,A1) the number of cells equal to the contents of A1. =Countif(Data,TODAY()) the number of cells containing current date =Countif(Data,TRUE) the number of cells containing logical true. =Countif(Data,"*") the number of cells containing text. =Countif(Data,"???") the number of cells containing exactly 3 characters. HTH Regards, Howard "Jamie" wrote in message ... My thanks to Gary"s Student and L. Howard Kittle. One question though, by putting the quotation marks around 0, doesn't that change it into a text? I thought Excel can understand numeric argument. "Jamie" wrote in message ... In a row of 20 cells from A1:T1, how can I count the number of cells that are greater than 0? Thanks for your help. Jamie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
Linear Mode
