Got a headache trying to figure this one.

[dsims]

Ok so i did some data grabbing and I got one page that's full of data. I'm trying to pull data to one sheet based off two criteria. So if you use vlookup i can pull data based off one cell. In this case for example: (a1) apples (b2) red ..now based off my data grabbing there is a lot of apples and many different red but only row has apple then red on the same row ..by using these 2 as reference to pull the number of red apples...sry if this is confusing.

 

[dsims]

This would work but on the LHPRHP page is a schedule and changes based off who is playing for the day. Trying to automate as much as I can.

Excuse where i wrote dodgers meant Nationals

 

[Joe4]

I understand. We are now just trying to do a "test" to debug it. We aren't going to leave things hard-coded.
Basically, "N/A" means it is not finding any matches. So, I am asking you, are you sure there really is a match for row 2?

If the screen prints are accurate for this point in time right now, please do exactly as I asked in the previous post.
That should help identify if there is a problem and what it might be.

This is how we "debug". Unless you can upload the file to a file sharing site and share it with us, I need you to work with me here and be sure to follow all instructions and answer all my questions.

 

[Peter_SSs]

This would suggest that you are using Google Sheets, not Excel. Is that the case? If so, your question is in the wrong forum.

 

[dsims]

I understand. We are now just trying to do a "test" to debug it. We aren't going to leave things hard-coded.
Basically, "N/A" means it is not finding any matches. So, I am asking you, are you sure there really is a match for row 2?

If the screen prints are accurate for this point in time right now, please do exactly as I asked in the previous post.
That should help identify if there is a problem and what it might be.

This is how we "debug". Unless you can upload the file to a file sharing site and share it with us, I need you to work with me here and be sure to follow all instructions and answer all my questions.

View attachment 96848

This would suggest that you are using Google Sheets, not Excel. Is that the case? If so, your question is in the wrong forum.

It says Google sheets on this app.. was thinking they was the same?

 

[dsims]

It says Google sheets on this app.. was thinking they was the same?

Joe4.. he said im on the wrong forum. Just asked my wife and she said excel isn't the same as Google sheets. Apologies

 

[Peter_SSs]

It says Google sheets

I have moved your thread to the correct forum.

 

[dsims]

I have moved your thread to the correct forum.

Thank you Peter_SSs

 

[Peter_SSs]

Thank you Peter_SSs

No problem, though I think that you should edit your Account details to remove Office 365 as your version since apparently it is not.

BTW, did you ever try the suggestion that I made way back in post #3? From what I can see it may possibly do the job.
Here is may sample data and results using that formula structure. Is this what you want?

dsims.xlsm
	A	B	C	D
2402
2403	Marlins			0.28
2404	Marlins	L		0.3
2405	Marlins	R		0.2
2406	Marlins			0.455
2407	Marlins			0.33
2408	Marlins			0.28
2409
2410
2411
2412
2413	Nationals			0.259
2414	Nationals	L		0.279
2415	Nationals	R		0.25
2416	Nationals			0.264
2417	Nationals			0.255
2418	Nationals			0.25
2419
Splits

dsims.xlsm
	A	B	C	D	E
1	Away		Away P		Away Batting avg
2	Nationals		R		0.25
3	Marlins		L		0.3
LHPRHP

Cell Formulas
Range	Formula
E2:E3	E2	=SUMIFS(Splits!D$1:D$3000,Splits!A$1:A$3000,A2,Splits!B$1:B$3000,C2)

 

[dsims]

No problem, though I think that you should edit your Account details to remove Office 365 as your version since apparently it is not.

View attachment 96849


BTW, did you ever try the suggestion that I made way back in post #3? From what I can see it may possibly do the job.
Here is may sample data and results using that formula structure. Is this what you want?

dsims.xlsm
	A	B	C	D
2402
2403	Marlins			0.28
2404	Marlins	L		0.3
2405	Marlins	R		0.2
2406	Marlins			0.455
2407	Marlins			0.33
2408	Marlins			0.28
2409
2410
2411
2412
2413	Nationals			0.259
2414	Nationals	L		0.279
2415	Nationals	R		0.25
2416	Nationals			0.264
2417	Nationals			0.255
2418	Nationals			0.25
2419
Splits

dsims.xlsm
	A	B	C	D	E
1	Away		Away P		Away Batting avg
2	Nationals		R		0.25
3	Marlins		L		0.3
LHPRHP

Cell Formulas
Range	Formula
E2:E3	E2	=SUMIFS(Splits!D$1:D$3000,Splits!A$1:A$3000,A2,Splits!B$1:B$3000,C2)

I tried every one of them.

 

[Peter_SSs]

So in post 28 what have I got wrong with my sample data or layout?
For may sample data are my results correct or not?