Thread
:
Sumproduct with If
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Glenn
external usenet poster
Posts: 1,240
Sumproduct with If
Angie wrote:
I hope someone can help me. How can I sum the products of columns A and B,
but only if the value in column C meets a certain criteria (like = 51)?
=SUMPRODUCT((A1:A100)*(B1:B100)*(C1:C100=51))
Reply With Quote
Glenn
View Public Profile
Find all posts by Glenn