=SUMPRODUCT(--(TRIM(A1:A10)<>"")), what does the "--" mean?

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Hi,

What does the "--" operator mean in the above worksheet equation?

Thanks.
 
=SUMPRODUCT(--(TRIM(A1:A10)<>""))

This portion will return an array of TRUE or FALSE:

TRIM(A1:A10)<>"")

The double unary "--" coerces these logical values to numeric values which
SUMPRODUCT can then add up to arrive at the result.

--TRUE gets coerced to 1
--FALSE gets coerced to 0

Try entering these formulas and see what happens:

=--TRUE
=--FALSE

Enter the number 10 in cell A1 then try this formula:

=--(A1=10)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 3
Variable Sumproduct Range 6
compound if equation? 7
in the worksheet, a1 to a10 have numbers. I want to calculate to a 2
unique records in specified range 5
another sumproduct with #value error... 5
SUMPRODUCT won't work on a row 5
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row 4

Back
Top