| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif([range], Cell?)
Hi All,
I've trying to do a countif on a range to count the number of records that exceed the value in cell C2. The value in C2 will vary so I can't just write that value into the formula. Anyone know how to do this? -- Adam ----------- Windows XP + Office Pro XP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif([range], Cell?)
Try this
=COUNTIF(A1:A10,""&C2) Mike "Adam" wrote: Hi All, I've trying to do a countif on a range to count the number of records that exceed the value in cell C2. The value in C2 will vary so I can't just write that value into the formula. Anyone know how to do this? -- Adam ----------- Windows XP + Office Pro XP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif([range], Cell?)
Awesome - thank you!
-- Adam ----------- Windows XP + Office Pro XP "Mike H" wrote: Try this =COUNTIF(A1:A10,""&C2) Mike "Adam" wrote: Hi All, I've trying to do a countif on a range to count the number of records that exceed the value in cell C2. The value in C2 will vary so I can't just write that value into the formula. Anyone know how to do this? -- Adam ----------- Windows XP + Office Pro XP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif([range], Cell?)
your welcome
"Adam" wrote: Awesome - thank you! -- Adam ----------- Windows XP + Office Pro XP "Mike H" wrote: Try this =COUNTIF(A1:A10,""&C2) Mike "Adam" wrote: Hi All, I've trying to do a countif on a range to count the number of records that exceed the value in cell C2. The value in C2 will vary so I can't just write that value into the formula. Anyone know how to do this? -- Adam ----------- Windows XP + Office Pro XP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif in a value range? | Excel Discussion (Misc queries) | |||
| Countif(len(Range)4) | Excel Discussion (Misc queries) | |||
| countif using a range | Excel Worksheet Functions | |||
| Countif with range name | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Linear Mode
