constant array in sumproduct

[reggieneo]

Dear All, how can I use a constant array to make this formula work? basically I need a count of the food that "aida" have between jan1 to jan 4. summing them is working but I have to do one formula for each food, hence my formula gets really long. appreciate the help. thanks. =SUMPRODUCT((F6:O6=B1)*(B8:B24=A1)*(F8:O24="egg","milk,"banana","cookies"))

aida

jan 1, 20

jan 4, 2

<tbody>
</tbody>

	jan 1, 2018	jan 2, 2018	jan 3, 2018	jan 4, 2018
aida	egg
almire		milk	banana
scott				cookies
jenn

<tbody>
</tbody>

 

[Special-K99]

Your formula is wrong, there's a missing quote, and you can't do the egg milk banana cookies search like that.

Please supply some properly formatted data.
Use this

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.