Count data in sheet 2 using date ranges selected in sheet 1

[Mbusi]

Hello,

I need a function that will give me the counts from other sheet. I have sheet 1 which has cell B1 and E1 where I select my criteria as dates then I have sheet2 where my data is. I want to get the counts of records in sheet 2 which match the date range selected in sheet 1 cell B1 and E1. here is the functions that I tried

=COUNTIFS(Sheet2!C3:C9,">="&B1)-COUNTIF(Sheet2!C3:C9,"<="&E1)
=COUNTIFS(Sheet2!C3:C9, ">=B1", Sheet2!C3:C9, "<=E1")
=COUNTIF(Sheet2!C3:C9,(Sheet2!C3:C9>=B1)*(Sheet2!C3:C9<=E1))

 

[Georgiboy]

Have you tried it as below:

=COUNTIFS(Sheet2!C3:C9,">="&B1, Sheet2!C3:C9,"<="&E1)

 

[Mbusi]

=COUNTIFS(Sheet2!C3:C9,">="&B1, Sheet2!C3:C9,"<="&E1)

Hello Georgiboy

Thank you very much this works well

 

[Georgiboy]

You are welcome, thanks for the feedback.