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

MrExcel MVP, Junior Admin
=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]
 

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??
 

Some videos you may like

This Week's Hot Topics

Top