Thread: Adding numbers based on Range
View Single Post
  #2  
Old June 18th, 2009, 03:22 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
external usenet poster
  
Posts: 7,584
Default Adding numbers based on Range
=SUMPRODUCT(--(C1:C10="Library"),(J1:J10))

--
Gary''s Student - gsnu200857