Helen,

You can only use COUNTIF (and SUMIF) when you have one condition - for
multiple conditions you need to use SUMPRODUCT, like so:

=SUMPRODUCT((C1:C100=1)*(D1:D100=1))

if you just want to count them, or this:

=SUMPRODUCT((C1:C100=1)*(D1:D100=1)*(A1:A100))

if you want to add them up.

Hope this helps.

Pete

On Mar 7, 8:23 pm, "Helen" wrote:
(please forgive me if this is a duplicate posting...)

I'm trying to do the following:

Count how many cells (rows) in column A that has the value 1 in Column C AND
value 1 in Column D?

Any suggestions?

Helen