Hello all,

I am trying to create a weekly summary page on a monthly missed pickup
report that counts the number of times a missed pickup appears (given codes
1-3) for a certain driver (name) within a date range. This is what I've
figured out so far:

=COUNTIF(K4:K33,"james")*AND(COUNTIF(M4:M33,"1")*A ND(COUNTIF(E4:E33,"1")))

This works halfway, but the data I need summarized is broken down into three
codes (the second countif section - choice of 1, 2, or 3). The third countif
section is my way of separating the weeks of the month (1-4). Currently, this
formula is counting even just the appearance of the name as 1 entry in
addition to the actual data codes I want counted. I may have gone the long
way around the mountain to do this, but I am stuck trying to figure out a way
to get this done. Ideally, I'd like to just put in a date range and name as
conditions and a code to search for and count.

Thanks in advance.