A ATL_Gabriel Jan 29, 2009 #1 =SUM(IF(Prod={"Product_12","Product_100"},Vol,0)) Question 2: Can wild cards * be used lookup values i.e. *_100.
=SUM(IF(Prod={"Product_12","Product_100"},Vol,0)) Question 2: Can wild cards * be used lookup values i.e. *_100.
M Max Jan 29, 2009 #2 Try it as just SUMIF then: =SUMIF(Prod,"*"&"_100",Vol) If above helps, pl press the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik
Try it as just SUMIF then: =SUMIF(Prod,"*"&"_100",Vol) If above helps, pl press the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik
