Quote:
Originally Posted by 676nova
I can't explain why, but there is something about SUMPRODUCT that confuses my. I think it has to do with using "*" in the equation to "multiply" things when you are actually not performing any multiplication.
|
Actually, it does do multiplication. It sums the multiplications done between the arrays specified.
But that raises something that I am confused about and maybe Peco can explain it. As explained by Microsoft, the arrays are supposed to be separated by commas. Sometimes I have to separate them with asterisks, as you say, or it doesn't work. Sometimes I have to use commas. Sometimes I have to use a comma here and an asterisk there.
Anyhoo, there seems to be an explanation here but I will have to read it later. Gotta hit the dusty trail.
http://www.mrexcel.com/forum/excel-q...-asterisk.html