SUMPRODUCT Question
 

When writing a Sumproduct formula, what does ,-- mean?

I know you can use +, what other symbols can you use?

Are there and's or or's symbols?


=SUMPRODUCT(--(Odyssey!$E$2:$E$898=B42),--(Odyssey!$AH$2:$AH$898="N")+
(Odyssey!$AQ$2:$AQ$898 <""))

Sharon

--
Message posted via http://www.officekb.com

SUMPRODUCT Question
 

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

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

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6482bff98a6e0@uwe...
When writing a Sumproduct formula, what does ,-- mean?

I know you can use +, what other symbols can you use?

Are there and's or or's symbols?


=SUMPRODUCT(--(Odyssey!$E$2:$E$898=B42),--(Odyssey!$AH$2:$AH$898="N")+
(Odyssey!$AQ$2:$AQ$898 <""))

Sharon

--
Message posted via http://www.officekb.com

SUMPRODUCT Question
 

You are the MAN!!!!!

Thanks so much

Bob Phillips wrote:
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

When writing a Sumproduct formula, what does ,-- mean?

[quoted text clipped - 6 lines]

Sharon

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1