Count number of occurrence between dates

[Wskip49]

I need to count the number of occurrences fall between week of dates. See Attached Week Of tab and Response data Column M.

[sanram]

You need this formula:

Please Login or Register  to view this content.

But your column M of Response Data contains Words, whether c$3 of Week Of contains Number. So it will result 0 every time. So, can you explain what is C$3 in Week Of?

[Wskip49]

C-3 is the week of July 4 through July 8 I think so what I'm trying to do is break down the data for each of the headers on the tab the week off. In the column M will be words like self cutting, suicide, homicide works that are in the headers

[sanram]

Then you can use this formula :

Please Login or Register  to view this content.

[Wskip49]

I can not get the [CODE]=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4)/CODE] to work at all. I'm trying to get it to count the number of times "Suicidal" or "Homicidal" show up in Column M. for each week of C4:C55.

[sanram]

Try this to count Suicidal :

Please Login or Register  to view this content.

And this to count Homicidal :

Please Login or Register  to view this content.