Count / Countif and Countifs

[rbobcat1]

I wrote a formula to count a column only if it meets the right dates but all I get is a 0 zero

formula
=COUNTIFS(Sheet1!I:I,">="&Sheet2!$D$2,sheet1!H:H,"<="&sheet2!$G$2)

I need to count I if it falls between the dates in H

the dates are entered on sheet 2 cells d2 and g2

my formula above returns a 0

 

[Deepak]

Can we have the workbook pls.

 

[rbobcat1]

uploded sheet

 

[Nebu]

Hi:

Formula in the colored cell.

Thanks

 

[Somendra Misra]

Hi,

You can also try:

=COUNTIFS(Sheet1!$A$1:$A$6,"<>",Sheet1!$C$1:$C$6,">="&Sheet2!$D$1,Sheet1!$C$1:$C$6,"<="&Sheet2!$G$1)

Regards,