# INDEX-MATCH with Multiple Row Criteria?

1. ## INDEX-MATCH with Multiple Row Criteria?

I'm trying to run an INDEX-MATCH-MATCH to pull store sales by month but my months and store accounts are in rows, not columns (see attached sample) and as far as I understand, one MATCH relates to rows and the other to columns. I'm ideally trying to do an INDEX(value, MATCH(row criteria #1, MATCH(row criteria #2. Please advise.

The real data has over 10K rows, so I'm looking for a formula where I can plug-and-play in 5 minutes (I'll have to be doing this regularly).

Thanks in advance for any help...

2. ## Re: INDEX-MATCH with Multiple Row Criteria?

How about
=SUMIFS(\$C\$3:\$C\$11,\$A\$3:\$A\$11,F\$2,\$B\$3:\$B\$11,\$E3)

3. ## Re: INDEX-MATCH with Multiple Row Criteria?

Also
Formula:
`Please Login or Register  to view this content.`

4. ## Re: INDEX-MATCH with Multiple Row Criteria?

Thanks for the help, Fluff13 and avk!

5. ## Re: INDEX-MATCH with Multiple Row Criteria?

You're welcome & thanks for the feedback

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1