SUMIFS with 2 row and 1 column Google sheets

[longhorn_1b3]

I'm trying to match in a value (either using SUMIFS or INDEX MATCH) based on multiple criteria (two rows, one column).

 

[alansidman]

I think we need more information. You have told us you wish to try to employ two different functions, but not specifically what you hope to achieve. Tell us more. Be specific. Show us a mocked up result.

 

[longhorn_1b3]

In another spreadsheet, I'm trying to match in values from the output (in white), based on the criteria I've highlighted. So for example, I want to match in the value for [Member #1, 1, A], which is 0.911...

 

[longhorn_1b3]

In another spreadsheet, I'm trying to match in values from the output (in white), based on the criteria I've highlighted. So for example, I want to match in the value for [Member #1, 1, A], which is 0.911...

*in another tab (not another spreadsheet)

 

[KRice]

I agree with @alansidman...some more information is needed, as it isn't clear what you are trying to do. It appears that you would like to identify data in the table that corresponds to certain matching criteria...and then do what with the data? This recent post does something similar, where the objective was to add the matching data.

Nested double vlookup and match function?

Hi Everyone, It's my first time posting and any help with my dilemma will be much appreciated! :-) I'm working on a new sales report for management. Since it will be updated on a regular basis, I am trying to automate it as much as possible. My raw data is sorted by month then category...

www.mrexcel.com

 

[alansidman]

What are you matching it to? Suggest you post a mocked up solution so we have a better idea of what you want. I'm still not getting it.

 

[Fluff]

Cross posted SUMIFS w/ row AND column criteria

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.