ExcelBanter - SUMPRODUCT formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMPRODUCT formula (https://www.excelbanter.com/excel-worksheet-functions/230141-sumproduct-formula.html)

Phyl

SUMPRODUCT formula

What does the "--" do in this expression?

=SUMPRODUCT(--(A2:A6="Active"), --(B2:B6=10),--(C2:C6))

Gary''s Student

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))

Jacob Skaria

SUMPRODUCT formula

An explanasion
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
--
If this post helps click Yes
---------------
Jacob Skaria

"Phyl" wrote:

What does the "--" do in this expression?

=SUMPRODUCT(--(A2:A6="Active"), --(B2:B6=10),--(C2:C6))

All times are GMT +1. The time now is 07:21 PM.