Double Countif

[Tennisguuy]

I am trying to count a value in a column of cells if the values are equal to a 1 or if the value is equal to a 2.

I tried the following formula:

=countif(N3:N500,1),countif(N3:N500),2) but i got an error

 

[AlphaFrog]

Try something like this...
=COUNTIF(N3:N500,1) + COUNTIF(N3:N500,2)

 

[Cease]

You can also use Countifs
=Countifs(N3:n5000,1,N3:n5000,2)
Should work exactly like AlphaFrog's post, just a different way to it.

 

[Tennisguuy]

thanks, both worked