Please help - Looking for a way to sum up for specific error codes that occur in multiple months.

[Joe]

Here is an example of what I am trying to capture: 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.

 

[Guest]

=countif(range,criteria)
=countif(A15,"SOE")

regards
FSt1

 

[Joe]

Thank you, however what formula would I use if there were other names
in column A that had the same error code of "soe" during those months?
But I only want to calculate how many "SOE" errors Joe had for that
quarter of business.

Your help is appreciated,
Joe

=countif(range,criteria)
=countif(A15,"SOE")

regards
FSt1

West Jane June SOE
North Bob July SOE

 

[Guest]

There's probably a more elegant way, but

=SUMPRODUCT(--(B2:B4="Joe"),--(D24="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]

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