Thread
:
SUMPRODUCT formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
external usenet poster
Posts: 11,058
SUMPRODUCT formula
It converts TRUE/FALSE into 1/0
--
Gary''s Student - gsnu200851
"Phyl" wrote:
What does the "--" do in this expression?
=SUMPRODUCT(--(A2:A6="Active"), --(B2:B6=10),--(C2:C6))
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student