Countif dependent on two columns

[katierb40]

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

 

[katierb40]

Nevermind... I figured it out.

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

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

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

Thank you!

 

[PCLIVE]

Maybe something like this:

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

HTH,
Paul