SUMPRODUCT seems like an easy way to handle multiple conditions with
out getting into arrays.

Yes, it is. Sumproduct is extemely useful and versatile.

What does the "--" mean? Does that convert TRUE from -1 to 1?

Yes, but it's a 2 step process. -TRUE = -1 then --1 = 1. Basically, it
converts TRUE to 1 and FALSE to 0.

Can "--" used in other formulas / VBA?

I'm not sure about VBA but it can be used in any formula where you need/want
to convert TEXT numbers/logicals into NUMERIC values.

See this for a detailed explanation:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Biff

wrote in message
oups.com...
Yes, the "502" is actually a text field.

SUMPRODUCT seems like an easy way to handle multiple conditions with
out getting into arrays.

What does the "--" mean? Does that convert TRUE from -1 to 1? Can
"--" used in other formulas / VBA?

Thanks!