Hi guys, here's my question.

How can I count cells in Column B, if Column A2:a594 equals "X". The count function does not allow me to do this, the formula I'd like is count(b2:594 if(a2:594=G4)). The formula is count the range in column b, if the range in column A equals cell G4.

Any help? Its all text, so no will the sum feature work?

Thanks