My brain is melting - no idea for a title

[silentcoates]

Hi

This has really got me stumped.

I have a list of twenty reasons starting from Cell H2. In column A I have a list of dates that I will manually enter over time. In column E i have a validation list box of the above twenty queries. In cells I2 and J2 I have two dates which I specify for reporting reasons.

I need a way of finding out how many times a reason appears in column E between two dates (I2 and J2) and enter the value next to that particular reason in column H.

Thanks, if you can help with this

 

[Andrew Poulsom]

still not working, weird

Did you try the formula I posted?