Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTtIF
I am trying to count numbers greater than or equal to a specific number
(column heading) and be able to copy down or across. In a range F52:H73 Criteria- Labeled C30 is =125 D30 is =150 My formula is =COUNTIF($F52:$H73,"$C$30") Any help is always appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTtIF
You should be fine if you use
=COUNTIF($F52:$H73,$C$30) "Jon" wrote: I am trying to count numbers greater than or equal to a specific number (column heading) and be able to copy down or across. In a range F52:H73 Criteria- Labeled C30 is =125 D30 is =150 My formula is =COUNTIF($F52:$H73,"$C$30") Any help is always appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTtIF
If you take the Quotes out it works. Can you explain why? Mine had "$C$30"
yours does not. "Duke Carey" wrote: You should be fine if you use =COUNTIF($F52:$H73,$C$30) "Jon" wrote: I am trying to count numbers greater than or equal to a specific number (column heading) and be able to copy down or across. In a range F52:H73 Criteria- Labeled C30 is =125 D30 is =150 My formula is =COUNTIF($F52:$H73,"$C$30") Any help is always appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTtIF
Because with the quotes you were telling Excel to count the cells that
contained "$C$30". By removing the quotes the formula uses the contents of cell C30's for evaluation "Jon" wrote: If you take the Quotes out it works. Can you explain why? Mine had "$C$30" yours does not. "Duke Carey" wrote: You should be fine if you use =COUNTIF($F52:$H73,$C$30) "Jon" wrote: I am trying to count numbers greater than or equal to a specific number (column heading) and be able to copy down or across. In a range F52:H73 Criteria- Labeled C30 is =125 D30 is =150 My formula is =COUNTIF($F52:$H73,"$C$30") Any help is always appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTtIF
Thanks again!
"Duke Carey" wrote: Because with the quotes you were telling Excel to count the cells that contained "$C$30". By removing the quotes the formula uses the contents of cell C30's for evaluation "Jon" wrote: If you take the Quotes out it works. Can you explain why? Mine had "$C$30" yours does not. "Duke Carey" wrote: You should be fine if you use =COUNTIF($F52:$H73,$C$30) "Jon" wrote: I am trying to count numbers greater than or equal to a specific number (column heading) and be able to copy down or across. In a range F52:H73 Criteria- Labeled C30 is =125 D30 is =150 My formula is =COUNTIF($F52:$H73,"$C$30") Any help is always appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|