"Mike McLellan" wrote in message
...
Bob,

Thanks - a great help. A couple of follow up questions:

1. What is the significance of the '--' in the formula?

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


2. If I simply wanted to count the number of non Blank cells in a column
based upon 2 similar conditions, what would I need to do?

Do you mean the number of items that meet the conditions? If so,

=SUMPRODUCT(--(A2:A200="Completed"),--(B2:B200=--"2005-01-09"),--(B2:B200<=
--"2005-01-13"))

That is exclude the part that has no condition, the ,C2:C200, which is a
summing part of the formula.