Show amount of times a value is present in a column (with exception)

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 "@''?

Hello and welcome to the forum. Try these:

Does contain:
=COUNTIFS(A:A;123;B:B;"*@*")

Does not contain:
=COUNTIFS(A:A;123;B:B;"<>*@*")