Hi All,
I have a formule where i want to display how many times a certain value (for instance 123) is present in column A.
I was able to do that with =COUNTIF(B:B;123)
In my column B is data that either does or doesn't contain a ''@''.
Is it possible to make a formula that does the COUNTIF calculation but only counts the values if the matching row (for instance A10 and B10) contains a ''@''.
Note that in row B the data is not just a @ but contains usually different types or e-mailadresses, the presence of @ would be able to determine the type of data column A represents.
Similat to that, would it also be possible to do the same formula, but only count if column B does NOT contain a "@''?
Bookmarks