| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Easy countif formula
Hi.
I'm trying to do an easy countif formula but it's not working. I want to count how many of the cells in a given range are less than another specific cell. I used: =COUNT(A1:A10,"<A11") Why won't this work? -- Thanks! Stephen |
|
#2
|
|||
|
|||
|
Hi!
Try this: =COUNTIF(A1:A10,"<"&A11) Biff "Stephen" wrote in message ... Hi. I'm trying to do an easy countif formula but it's not working. I want to count how many of the cells in a given range are less than another specific cell. I used: =COUNT(A1:A10,"<A11") Why won't this work? -- Thanks! Stephen |
|
#3
|
|||
|
|||
|
That worked!
Thanks! -- Thanks! Stephen "Biff" wrote: Hi! Try this: =COUNTIF(A1:A10,"<"&A11) Biff "Stephen" wrote in message ... Hi. I'm trying to do an easy countif formula but it's not working. I want to count how many of the cells in a given range are less than another specific cell. I used: =COUNT(A1:A10,"<A11") Why won't this work? -- Thanks! Stephen |
|
#4
|
|||
|
|||
|
You're welcome.
Biff "Stephen" wrote in message ... That worked! Thanks! -- Thanks! Stephen "Biff" wrote: Hi! Try this: =COUNTIF(A1:A10,"<"&A11) Biff "Stephen" wrote in message ... Hi. I'm trying to do an easy countif formula but it's not working. I want to count how many of the cells in a given range are less than another specific cell. I used: =COUNT(A1:A10,"<A11") Why won't this work? -- Thanks! Stephen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy formula, but need help please | Excel Worksheet Functions | |||
| Countif formula and then some... | Excel Worksheet Functions | |||
| Easy formula question | Excel Worksheet Functions | |||
| Easy formula Question | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Linear Mode
