Counif with criteria

Hi guys

As a new user, I, first of all, wanna say that i love this board and have been using it extensively for the past few months. I've now come across a question I can't find an answer for - so hope you guys can help me out with this one (it should be a simple one ).

I've got 3 coloumns:

A = numbers 1-4 repetitively

B = random numbers

In C i want to find the number of times a specific number occurs in B if A is say 3:

I believe it should be something like: C = if(a1=3,countif(b1:b##,

Thx in advance.

Thanks a lot man. It worked.

Thanks Tony Valko. That was the exact function I was looking for.

Cheers!