SUMPRODUCT Formula for Multiple Conditions/Colums

[ezlea1]

Hello. I've searched all over and tried everything I've found to come up with a formula for the following:

I have a master sheet with 200 or so User IDs, months of the year, and production data (the chart below is just a small sample). I want to be able to enter a User ID in cell B10 and a month in cell B11 and have the result in B12. There are some blank/empty cells throughout the sheet. I've tried so many different things that I've gotten totally confused. Any help would be greatly appreciated. Thanks.

This is not working: SUMPRODUCT(--(A1:G7=B10),--(A1:G7=B11),--(A1:G7="Errors"),(A1:G7))

	Jan	Jan	Feb	Feb	Mar	Mar
User ID	Lines	Errors	Lines	Errors	Lines	Errors
TJC0546	107	0	178	2	146	2
DJA0047	416	1	324	6	361	3
DLB0009	100	0			210	0
TJC2168	250	1	200	0	239	0
TJC9735	301	1	280	1	294	3
Lines
User ID:	TJC2168
Month:	Feb
Lines:	200

<tbody>
</tbody>

 

[Eric W]

Try:

=SUMPRODUCT(B3:G7*(A3:A7=B10)*(B1:G1=B11)*(B2:G2="Errors"))

 

[ezlea1]

Try:

=SUMPRODUCT(B3:G7*(A3:A7=B10)*(B1:G1=B11)*(B2:G2="Errors"))

Thanks Eric!

 

[Eric W]

Happy to help!