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