"Nadine" wrote:
Excel 2003
Col A Col B Col C
1 No Count this cell
I need to count all the cells in Col C if Col A=1 and Col B=No

To "count" all the rows that meet that conditions in columns A and B:

=sumproduct((A1:A100=1)*(B1:B100="no"))

To __sum__ all the cells in column C that meet the conditions in columns A
and B:

=sumproduct((A1:A100=1)*(B1:B100="no"),C1:C100)