(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

So ... what does Column A have to do with the count?
=Sumproduct((C1:C100=1)*(D1:D100=1))

Do you want to check if the cell in Column A contains *anything?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A100<""))

OR ... if Column A is *not* equal to 0?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A1000))


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Helen" wrote in message
...
(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

If this is a real problem not just an example, (ie that there really will be
1's used), then a simple SUMIF() should do it:

=SUMIF(A1:A10,1,C1:C10)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Ragdyer" wrote in message
...
So ... what does Column A have to do with the count?
=Sumproduct((C1:C100=1)*(D1:D100=1))

Do you want to check if the cell in Column A contains *anything?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A100<""))

OR ... if Column A is *not* equal to 0?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A1000))


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Helen" wrote in message
...
(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

What happens when Column C contains a 1, and Column D contains a 2 and/or a
3?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sandy Mann" wrote in message
...
If this is a real problem not just an example, (ie that there really will
be
1's used), then a simple SUMIF() should do it:

=SUMIF(A1:A10,1,C1:C10)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Ragdyer" wrote in message
...
So ... what does Column A have to do with the count?
=Sumproduct((C1:C100=1)*(D1:D100=1))

Do you want to check if the cell in Column A contains *anything?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A100<""))

OR ... if Column A is *not* equal to 0?
=Sumproduct((C1:C100=1)*(D1:D100=1)*(A1:A1000))


--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Helen" wrote in message
...
(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

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