Most Common Accuring Text within a Data Set within a Time Period

I have a Data Table called FTCF with a number of columns one is called Date another Other Comments and Suggestions

FTCF[Date]

FTCF[Other Comments and Suggestions]

to find the most occurring text with in Other Comments and Suggestions i used the below and it works perfectly with alt+ctrl+Enter to get it to calculate

=INDEX(FTCF[Other Comments and Suggestions],MATCH(MAX(COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions])),COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions]),0))

this is the overall view i want to get a date period of last 3 months so joining a code from earlier in the project which i had help with from here

http://www.excelforum.com/excel-programming/832822-calculate-entries-based-on-date-entered-2.html

i made this

=INDEX(((FTCF[Other Comments and Suggestions])*((FTCF[Date])>=(A98))*((FTCF[Date])<(C98))),MATCH(MAX(COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions])),COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions]),0))

it does not work i get #Value error

so i tried

=INDEX((SUMPRODUCT(FTCF[Other Comments and Suggestions])*((FTCF[Date])>=(A98))*((FTCF[Date])<(C98))),MATCH(MAX(COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions])),COUNTIF(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions]),0))

which returns "0" its should be text string

your thoughts please anything will do as it might trigger an event which leads me to the answer thanks