| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick Question
Nikki, It is called the double unary operator. It coerces excel to treat TRUE/FALSE arrays to 1/0 arrays. 1 being if the condition is TRUE and 0 if the condition is FALSE. That way, if all the conditions are TRUE the result of the SUMPRODUCT for that row will be 1 and 0 if FALSE so when it sums it is only counting 1 for each instance that all conditions are met. This link can explain it more and other uses of the formula. Don't worry about the name thing! HTH Steve http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=506520 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
| Quick Question | Excel Discussion (Misc queries) | |||
| Excel Colours - Quick Question | Excel Discussion (Misc queries) | |||
| Quick formula question | Excel Worksheet Functions | |||
| Quick question: What does "--" in an equation do? | Excel Worksheet Functions | |||
Threaded Mode
