| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a Counting question
hi to all
I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a Counting question
=SUMIF(B5:B1525,"" & A3)
-- Jacob "cinnie" wrote: hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a Counting question
Jacob, the OP wants Count, not Sum.
Regards, Fred "Jacob Skaria" wrote in message ... =SUMIF(B5:B1525,"" & A3) -- Jacob "cinnie" wrote: hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a Counting question
=COUNTIF(B5:B1525,"="&A3)
"cinnie" wrote: hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a Counting question
Thanks teethless mama - that what I needed
-- cinnie "Teethless mama" wrote: =COUNTIF(B5:B1525,"="&A3) "cinnie" wrote: hi to all I'm sure this is easy, but I'm new to Excel. I need a function that will COUNT all the numbers in a range (B5:B1525) equal to or greater than the value in A3. (all values are positive integers) thanks in advance -- cinnie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Question! | Excel Worksheet Functions | |||
| Counting Question | Excel Discussion (Misc queries) | |||
| Another counting question! | Excel Worksheet Functions | |||
| Counting Question | Excel Worksheet Functions | |||
| Counting Question | Excel Discussion (Misc queries) | |||
Hybrid Mode
