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.

=countif(range,criteria)
=countif(A1:D5,"SOE")

regards
FSt1

"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.

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



FSt1 wrote:
=countif(range,criteria)
=countif(A1:D5,"SOE")

regards
FSt1

"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
West Jane June SOE
North Bob July SOE

Thanks for helping me.

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.

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.