"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.