View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rob Edwards Rob Edwards is offline
external usenet poster
 
Posts: 17
Default SUMIF of adjacent variable cells

Assuming column A has the values & column B the description, use the
following...

=SUMIF(B:B,"Bags",A:A)

Rob Edwards

Always look on the bright side of life!

*** Sent via Developersdex http://www.developersdex.com ***