Countif function

[Rajesh Kumar Bhupal]

Hi ,

I have a set of data in sheet1 and in sheet2 and i have designed a report based on sheet1. There are two different cells in sheet2 where G1 is TO date and H1 is FROM date which need to enter manually. 

In I1 i require the count of text named "APPLE" to be displayed between the FROM date and TO date which is entered in G1 and H1. 

[#2]

You have to use something like this:

=COUNTIFS(Sheet1!$B$2:$B$179,C2,Sheet1!$A$2:$A$179,">="&A2,Sheet1!$A$2:$A$179,"<="&B2)

Please find the attachment.