# Count If

#### majorqt75

##### New Member
sheet 1 Column M has if statement that shows days outstanding, =IF([@Status]="",TODAY()-[@[Date Back Charge Issued]],"") which works perfect, now on sheet 3 I want count how many instances in column M are between 0-60, there are 6 instances but it tells me there is 30, when I use formula, =COUNTIF(Sheet1!M:M,">60")

#### Joe4

=COUNTIF(Sheet1!M:M,">60")
That counts how many are greater than 60. If you want the number between 0 and 60, try:
Code:
``[COLOR=#333333]=COUNTIFS(Sheet1!M:M,">=0",[/COLOR][COLOR=#333333]Sheet1!M:M,"<=60"[/COLOR][COLOR=#333333])[/COLOR]``

• majorqt75

#### JoeMo

##### MrExcel MVP
sheet 1 Column M has if statement that shows days outstanding, =IF([@Status]="",TODAY()-[@[Date Back Charge Issued]],"") which works perfect, now on sheet 3 I want count how many instances in column M are between 0-60, there are 6 instances but it tells me there is 30, when I use formula, =COUNTIF(Sheet1!M:M,">60")
Maybe Sheet1 should be Sheet3??

#### majorqt75

##### New Member
Perfect Thank you!