Forum Discussion
Need help counting occurrences of text only when adjacent cell has numbers
Need help with formula to count the number of times "ABC" occurs if the adjacent cell has numbers in it. (i.e. not counting occurrence when adjacent cell is blank). The below spreadsheet show total a...
Let's say the first column is A2:A10.
=COUNTIFS(A2:A10, "ABC", B2:B10, "<>")
or if the numbers will always be positive
=COUNTIFS(A2:A10, "ABC", B2:B10, ">0")
Thank You!