Forum Discussion

Rajesh Kumar Bhupal's avatar
Rajesh Kumar Bhupal
Copper Contributor
Dec 07, 2017

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 ent...
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 07, 2017

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.

 

Resources