Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can someone explain to me the difference between using -- and using * in the
following formula? =SUMPRODUCT(--(H$2:H$65),--($F$2:$F$65=$G86)) vs. =SUMPRODUCT((H$2:H$65)*($F$2:$F$65=$G86)) Does one of these operators have any benefit over the other? Not sure it matters for this question but H2:H5 are dollar values, F2:F65 are project names, and G86 is a project name. Both formulas above give the same, correct, result. Thanks for any insight. Dave -- Brevity is the soul of wit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |