"Maddie" wrote in message
...
What do the -- represent????

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

Can I still use the quotes with a number.
Example - Instead of "pp/nc" I want it to bring back those that have a
number 4 in the column??

The quotes signify text, so if testing for a number, remove the quotes,
express the number without them.