Extract a value in a range with specific date, category name, and store name

I need help writing a formula that will extract the number of "Donuts" purchased in Column "B" on my spreadsheet that looks at Column "A" and the value extracted is based on store name and date.

i.e. Store Name: 069 - 331381 - CAFE
Date: 07/29/2018

On my spreadsheet I have 4 stores listed in Column "A" and it is a report for 1 week so each store has 7 different days of donuts purchases. I created a graph to the right and color coordinated it by store. I was hoping someone can help me write a formula that will find the values based on the store name and the specific date.

Thank You in advance for anyone who can help me.

Jason

As long as the number of rows and relative location of "Donuts" is consistent throughout the data source this works.

In I8 filled down and across.

Formula:

Please Login or Register  to view this content.

If the data varies in spacing (row counts) or relative location of the product you'll need an array formula.

Please let me know, and I'll do that.

In what way does this differ from your other thread here?

https://www.excelforum.com/excel-for...-criteria.html

I asked how this query differs from your other thread.