count if and
 

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!

count if and
 

SUMPRODUCT(($D$3:$D$3536="C")*($J$3:$J$3536<""))


"tom" wrote:

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!

count if and
 

Thank you for the quick response, but it returns #N/A

Any ideas?


"Teethless mama" wrote:

SUMPRODUCT(($D$3:$D$3536="C")*($J$3:$J$3536<""))


"tom" wrote:

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!

count if and
 

Do you have any N/A's in either of the two ranges?

Did you change the formula? If yes, then post what you used.



On 05/15/2010 00:07, tom wrote:
Thank you for the quick response, but it returns #N/A

Any ideas?


"Teethless mama" wrote:

SUMPRODUCT(($D$3:$D$3536="C")*($J$3:$J$3536<""))


"tom" wrote:

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!

count if and
 

Hi Dave,

I did have a few N/A's and after removing them it worked fine!

Thank you for your help*


"Dave Peterson" wrote:

Do you have any N/A's in either of the two ranges?

Did you change the formula? If yes, then post what you used.



On 05/15/2010 00:07, tom wrote:
Thank you for the quick response, but it returns #N/A

Any ideas?


"Teethless mama" wrote:

SUMPRODUCT(($D$3:$D$3536="C")*($J$3:$J$3536<""))


"tom" wrote:

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!

.