| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT - comma versus semicolon
A1:E1 3 5 6 3 2
=SUMPRODUCT((A1:E1)*{1;2;3;4;5}) returns 285 =SUMPRODUCT((A1:E1)*{1,2,3,4,5}) returns 53 I use evaluate formula and I know what the above formulae do. I am familiar with commas but semicolons are new to me. Anyone knows of any documentation on SUMPRODUCT and semicolon? Don't think I saw semicolon in Bob's paper. By the way, SUM+CSE will return the same results respectively. Please feel free to comment. Thanks. Epinn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT search versus other method | Excel Discussion (Misc queries) | |||
| SUMPRODUCT --- semicolon (;) vs. plus sign (+) | Excel Worksheet Functions | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
