Countif dependent on two columns
 

I've gone through all the previous messages and tried very hard to impliment
the suggestions to help me with my issue.

I'm trying to count if one column has a certain criteria, count the other
column.

For example:

column b column x
Red 75.00
Blue 25.00
Red 50.00
Green 125.00
Blue
Red 75.00

Therefore, I want to count if column B is noted as "Red", and has a dollar
amount in column x. Doesn't matter how much.

Please help and thank you for your assistance.

Cathy

Countif dependent on two columns
 

Nevermind... I figured it out.

You guys are great here...I used the following:

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

This was recommended by "Toppers" in a previous post.

Thank you!

"katierb40" wrote:

I've gone through all the previous messages and tried very hard to impliment
the suggestions to help me with my issue.

I'm trying to count if one column has a certain criteria, count the other
column.

For example:

column b column x
Red 75.00
Blue 25.00
Red 50.00
Green 125.00
Blue
Red 75.00

Therefore, I want to count if column B is noted as "Red", and has a dollar
amount in column x. Doesn't matter how much.

Please help and thank you for your assistance.

Cathy

Countif dependent on two columns
 

Maybe something like this:

=SUMPRODUCT(--(B1:B100="Red"),--(X1:X100<""))

HTH,
Paul


--

"katierb40" wrote in message
...
I've gone through all the previous messages and tried very hard to
impliment
the suggestions to help me with my issue.

I'm trying to count if one column has a certain criteria, count the other
column.

For example:

column b column x
Red 75.00
Blue 25.00
Red 50.00
Green 125.00
Blue
Red 75.00

Therefore, I want to count if column B is noted as "Red", and has a dollar
amount in column x. Doesn't matter how much.

Please help and thank you for your assistance.

Cathy