COUNTtIF

J

Jon

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!
 
J

Jon

If you take the Quotes out it works. Can you explain why? Mine had "$C$30"
yours does not.
 
D

Duke Carey

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
 
J

Jon

Thanks again!

Duke Carey said:
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
Click to expand...
 
Top