Hi All,

The basic idea is that I want to count number of eating, sleeping, drinking, and so on. based on the date cell value.
Refer screen grab to get the idea of what I am talking about.
Count range.jpg

For Example : When I enter value against date as 'A14' or 6/27/2016, it should give me results as :
Eating - 2
Sleeping - 2
Drinking - 1
Running - 1

So here the range where I want to count by desired text gets changed on the basis of value entered in D18 of the date

Help me guys.

Thanks in advance.