SUMPRODUCT Question

[s2m via OfficeKB.com]

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

 

[Bob Phillips]

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]

You are the MAN!!!!!

Thanks so much

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