Count "letters" between given dates in range

[InvalidTxtString]

I need in the sheet July, look up how many "F"s and etc. each person have between a given date(July

http://www.excelforum.com/attachment...1&d=1470502736

[José Augusto]

Hi
Try yhis formula in July!AU6 and drag down and right

=SUMPRODUCT((Per!$I$4:$NI$224=July!AU$5)*(Per!$A$4:$A$224=July!$AT6)*(Per!$I$3:$NI$3>=July!$AT$2)*(Per!$I$3:$NI$3<=July!$AT$3))

[Glenn Kennedy]

Here's the file..

[Glenn Kennedy]

... or this:

=SUMPRODUCT((Per!$A$4:$A$37=July!$AT6)*--(Per!$I$4:$AL$37=July!AU$5))

i just selected the block of cells related to July...

Extend the ranges down as far as needed.

[Glenn Kennedy]

Thanks for the Rep. However, it would be helpful for other users if you would comment on which (either or both) solution(s) worked for you. Also, if your question is now closed, it would be good to mark the thread as solved.