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 formu...
PeterBartholomew1
May 17, 2021Silver Contributor
= COUNTIFS(colA, "x", colB, "<>")