| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just a question regarding a formula operator.
Hi.
I've recently been introduced to the following formula through Newsgroups: =SUMPRODUCT(--(Sheet1!$B$2:$B$9000=1),--(Sheet1! $C$2:$C$9000=14)) It works for my needs, however, I'm trying to understand it for other applications. What do the -- operators do? I've never seen them before and can't find a reference. Thanks!! Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Operator Question | Excel Discussion (Misc queries) | |||
| What does ^ operator mean in a formula?? | Excel Worksheet Functions | |||
| What does ! mean as an operator within a formula | Excel Discussion (Misc queries) | |||
| "--" operator in a formula | Excel Worksheet Functions | |||
![Todd S[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
