You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I want a formula to return the number of cells in this column with the values "Matched" or "Closed". This seems like it should be simple, but for the life of me I cannot find a way to do it. Right now, I've got "Matched" returning to one cell and "Closed" returning to another cell and then I've got a sum formula in the "Total" cell. But it seems like it should be possible to just count the two together into the Total cell.
MacBook Pro 15″
Let's say the count of "Matched" is in C2, the count of "Closed" is in D2, and the total in cell E2 is the formula =C2+D2.
Copy the formula from C2 and paste it where you see C2 in the "total" formula.
Copy the formula from D2 and paste it where you see D2 in the "total" formula.
Cells C2 and D2 will no longer be necessary.
Next time you can do it all in one cell rather than go through all this copy/paste stuff.
Sometimes when I am trying to create a really complicated one-cell formula, I will do it piece by piece in other cells so it is easier to write and much easier to debug then I'll do this copy-paste stuff to get it all into one cell. The resulting one-cell formula will be complex and pretty much unreadable but it will work.
Alternatively, if the column of words is column B:
=COUNTIF(B,REGEX("^(matched|closed)$",0))
This will count occurrences of either word. ^ means the start of the string. $ means the end of the string. | means "or". The 0 is for case-insensitive.
Huh. I did not think that would work, but it did. Thank you very much!
Return count of cells containing X or Y (text values)
