Change range Dynamically based on some other cell value in that range and then use count

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.

Bingo, this is what I was looking for. Thanks, it solved my query.

It would be really great and helpful of u if you could explain how you did it i.e. how the formula works.

Formula:

Please Login or Register  to view this content.

Apart from that I was not getting correct result if I append more columns, but anyhow I understood the formula(for column append part only) and replaced the number of columns from 7 to number of columns I added and it worked.

Thnks, you made my day.!!!