Formula Syntax Help

[Ikaabod]

I recently saw someone using the following formula on these boards:
=SUMPRODUCT(--(Sheet1!E2:E65536="east"),--(Sheet1!I2:I65536 >38717))

I'm not familiar with this "--" and can't seem to figure out it's exact
usage.

Also, what's the difference between Sumproduct and Sum?

Thanks much,
Ikaabod

 

[Dave Peterson]

Bob Phillips explains =sumproduct() in detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Ikaabod]

That will save me heaps of time in the future. Cheers!

-Ikaabod