Exclude values where text contains

Occasional Contributor

Hi Tech community,

 

I want to do a counta formula on a column range (B2:B10) but I only want to do it if values in another column (A) are equal to a certain value. How would I construct that formula?

 

 

1 Reply
= COUNTIFS(colA, "x", colB, "<>")