Which group is that in?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Epinn" wrote in message
...
Bob and Roger,

...... it is not a SP matter particularly......<<

I think you know me by now. Remember how I thought Boolean was for
SUMPRODUCT only? This is no different; I thought this comma/semicolon issue
is SUMPRODUCT related. This is a case of history repeating and SUMPRODUCT
addiction. Please feel free to laugh; consider this your joke for the day.

My memory is coming back. Thank you, Mr. McGimpsey for your help. I have
seen formulae using comma and semicolon before. I was thrown off by the
fact that there was only one number and then a semicolon. You know I am
used to seeing 1,2;3,4;5,6 ...... something like that.

I have to refresh myself some more and I won't close this thread yet.

Have you read my discovery of today? Under the thread "Interpreting comma
......," I talked about =IF(A1,) with A1 containing all sorts of values.
Lately, I seem to have some affinity with comma. <G

Epinn

"Bob Phillips" wrote in message
...
I didn't include in the paper as it is not a SP matter particularly, more to
do with how arrays are handled. But it is interesting, and I might try to
include something about it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Epinn" wrote in message
...
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