I am trying to track 3 error types (type1, type2, type3) for two different
regions (region1, region2). Column D (D1020) lists the regions in varying
orders while Columns G,H,I (G10:I20) list the error types if there is one.

Ex: ~Row 10 has region1(D10) containing errors: type1(G10) type2(H10)
type3(I10)
~Row 11 has region2(D11) containing errors: type1(G11) type2(H11)
~Row 12 has region1(D12) containing errors: type2(G12)

Every time Column D contains “region1” I want it to count the corresponding
errors in that row Columns G:I. Same for “region2”.

So in my example region1 should have 4 errors while region2 should have 2
errors. Hope this makes sense, I really appreciate the help.

Try this:

=SUMPRODUCT((D1020="region1")*(G10:I20<>""))
=SUMPRODUCT((D1020="region2")*(G10:I20<>""))

I'm assuming that G:I will contain only error types and no other text or
numeric values. So, all you need to do is count those cells in G:I that
aren't empty/blank.

--
Biff
Microsoft Excel MVP


"bSB" <(E-Mail Removed)> wrote in message
news:1FDD2BE9-D15E-45D3-A300-(E-Mail Removed)...
>I am trying to track 3 error types (type1, type2, type3) for two different
> regions (region1, region2). Column D (D1020) lists the regions in
> varying
> orders while Columns G,H,I (G10:I20) list the error types if there is one.
>
> Ex: ~Row 10 has region1(D10) containing errors: type1(G10) type2(H10)
> type3(I10)
> ~Row 11 has region2(D11) containing errors: type1(G11) type2(H11)
> ~Row 12 has region1(D12) containing errors: type2(G12)
>
> Every time Column D contains "region1" I want it to count the
> corresponding
> errors in that row Columns G:I. Same for "region2".
>
> So in my example region1 should have 4 errors while region2 should have 2
> errors. Hope this makes sense, I really appreciate the help.
>