SUMPRODUCT Formula for Multiple Conditions/Colums

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


User ID: TJC2168
Month: Feb
Lines: 200

Originally Posted by modytrane

See attached example.
Does that work for you.
Simple Offset / Match formula will work if the data is setup correctly.
You can adjust the ranges.

Formula used in B13:

HTML Code: 

Does the trick. Thanks modytrane!

Originally Posted by FDibbins

Using the sample from mod...

	A	B	C	D	E	F	G
1		Jan	Jan	Feb	Feb	Mar	Mar
2		Lines	Errors	Lines	Errors	Lines	Errors
3	A	1	2	3	4	5	6
4	B	6	7	8	9	10	11
5	C	12	13	14	15	16	17
6	D	18	19	20	21	22	23
7	E	24	25	26	27	28	29
8	F	30	31	32	33	34	35
9
10
11	USER ID	D
12	Month	Jan
13	Lines	18

This is a more efficient way to do what you want...
=INDEX($B$3:$G$8,MATCH(B11,$A$3:$A$8,0),MATCH(B12,$B$1:$G$1,0))
This is pulling from Lines column, if you need to pull from Errors...
=INDEX($B$3:$G$8,MATCH(B11,$A$3:$A$8,0),MATCH(B12,$B$1:$G$1,0)+1)

Works as well. Thanks FDibbins!