Thread
:
Adding numbers based on Range
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
external usenet poster
Posts: 11,058
Adding numbers based on Range
=SUMPRODUCT(--(C1:C10="Library"),(J1:J10))
--
Gary''s Student - gsnu200857
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student