Countif dependent on two columns

  • Thread starter Thread starter katierb40
  • Start date Start date
K

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
 
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!
 
Back
Top