|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 10:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com