Count If

[majorqt75]

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:

[COLOR=#333333]=COUNTIFS(Sheet1!M:M,">=0",[/COLOR][COLOR=#333333]Sheet1!M:M,"<=60"[/COLOR][COLOR=#333333])[/COLOR]

 

[JoeMo]

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]

Perfect Thank you!

 

[Joe4]

You are welcome.