The above formula will give the result for foods, when food is selected,
and when beverage is selected, it will give the beverage results.

If you don't need the above scenario, then can you explain your
position what it is right now in sheet1.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373824