Forum Discussion
Countif function
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.
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.
