"Nadine" wrote:
Now I need to sum a different column based on the
same condition used for the "count". for those that
meet the same criteria, I now need to sum col D.

Isn't that simply a modification to the "sum" formula that I already
provided, to wit:

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

If that does not work for you, you will need to be more clear about your
requirements.


----- original message -----

"Nadine" wrote:
Thanks so much Joe. I used the one to "count" and it worked perfectly. Now
I need to sum a different column based on the same condition used for the
"count". for those that meet the same criteria, I now need to sum col D.
Any ideas on that one? Thank you!!!

"Joe User" wrote:

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