Forum Discussion
fcbda
May 17, 2021Copper Contributor
Exclude values where text contains
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
- PeterBartholomew1Silver Contributor= COUNTIFS(colA, "x", colB, "<>")