What does the "--" in the formula do: =SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))))? <br /> <br /> I have looked up the use of the double dash in formulas but I cannot find any reference to it?<br /> <br /> kbf

Support is Online

We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.

Official support hours

Monday To Friday

From 09:00 To 17:30

New

What does the "--" in the formula do: =SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))))?

Excel

Friday, 24 August 2018

0 Replies

2.9K Visits

Votes

Undo

What does the "--" in the formula do: =SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))))?

I have looked up the use of the double dash in formulas but I cannot find any reference to it?

kbf

There are no replies made for this post yet.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Changelog

Feature Tutorials

Get Help?

What does the "--" in the formula do: =SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))))?

Follow Us