Thread: COUNTtIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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!