Count "letters" between given dates in range

**InvalidTxtString** · 08-06-2016, 12:59 PM

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** · 08-06-2016, 01:29 PM

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

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 08-06-2016, 01:35 PM

... 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** · 08-06-2016, 01:38 PM

Here's the file..

**Glenn Kennedy** · 08-07-2016, 04:50 AM

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.

Count "letters" between given dates in range

LinkBack

Thread Tools

Rate This Thread

Display

Count "letters" between given dates in range

Re: Count "letters" between given dates in range

Re: Count "letters" between given dates in range

Re: Count "letters" between given dates in range

Re: Count "letters" between given dates in range

Thread Information

Users Browsing this Thread

Similar Threads

Need to count the numnber of "agree", "disagree" and "N/A" in a filtered list

[SOLVED] How to USE """"" cells count """"" change font color

[SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row

How to make Excel count specific letters as "1" and then have them summed up?

Why does =countif(range,"<>""") count empty cells?

Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next

[SOLVED] what is syntax for if(between range of dates,"Q1","Q2")?

Bookmarks

Bookmarks

Posting Permissions