What is "--" in Excel Formula (SUMPRODUCT)
 

I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well!

Here is a sample formula where it is used along with a number of named ranges/arrays:

SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate

What is "--" in Excel Formula (SUMPRODUCT)
 

On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote:
I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well!



Here is a sample formula where it is used along with a number of named ranges/arrays:



SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate

Hi
It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation

What is "--" in Excel Formula (SUMPRODUCT)
 

Excellent. Thanks for the lesson. I understand now!

On Thursday, November 15, 2012 12:57:19 PM UTC-8, Cimjet wrote:
On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote:

I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well!







Here is a sample formula where it is used along with a number of named ranges/arrays:







SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate



Hi

It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation



On Thursday, November 15, 2012 12:57:19 PM UTC-8, Cimjet wrote:
On Thursday, November 15, 2012 3:16:48 PM UTC-5, IHN Warrior wrote:

I am trying to understand a formula and cannot find Excel documetnation on what the "--" (operator ?) means in Excel 2010. Can someone give me a brief explanation and point me to some documentation where I can at least understand what this is called? I used to think I knew excel pretty well!







Here is a sample formula where it is used along with a number of named ranges/arrays:







SUMPRODUCT(--(Planner_Type="I"),--(Planner_Category=Dashboard!$R20),INDIRECT($D$22)) *Filter_Currency_ExchangeRate



Hi

It's called double unary, it changes "True/False" into 1 and 0's that Sumproduct can use fot its calculation