View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chazmac
 
Posts: n/a
Default Lookup same word "value" across multiple cells


Hi, I'm wondering if there is a way to lookup every instance of say
"blue sheets" in an excel file, move left 2 columns, pick up the
numerical value that resides in that column for every instance of "blue
sheets" and give a sum total in a cell at the bottom of the sheet? I'm
an excel formula "newbie" so please be kind in any explanation. :-)


--
chazmac
------------------------------------------------------------------------
chazmac's Profile: http://www.excelforum.com/member.php...o&userid=28972
View this thread: http://www.excelforum.com/showthread...hreadid=487042