Thank you very much! This formula works fine and you have saved me so
much time! :-)


JMB wrote:
There's probably a more elegant way, but

=SUMPRODUCT(--(B2:B4="Joe"),--(D2:D4="SOE"),(C2:C4="June")+(C2:C4="July")+(C2:C4 ="August"))

change ranges as needed. Sumproduct cannot accomadate entire columns (such
as A:A or A1:A65536, but A1:A65535 will work).


"Joe" wrote:

Here is an example of what I am trying to captu Every SOE entry that
Joe during the months of June, July, and August. According to this
example the total is 3.

(A) (B) (C) (D)
REGION NAME MONTH ERROR CODE
EAST JOE JUNE SOE
EAST JOE JULY SOE
EAST JOE AUGUST SOE

Thanks for helping me.