Formula for counting specific nonblank cells in column, dependant on data in anothr column

Hey guys!

So i have two sheets. The first sheet has data of all candidates that have taken different sessions, and data about the attendance on those sessions. What I need is a formula that counts the nonblank cells in a column, dependent on the label of that row.

For example Sheet1 looks like this:

Please Login or Register  to view this content.

Sheet2 should look like this:

Please Login or Register  to view this content.

Thus I need a formula for cells in the second sheet that counts the nonblank cells in the 'Attendance' column.

I managed to figure out a formula that summed up the values in another column, dependent on the sessioncode, that formula looked like this:

{=SUM(IF('Sheet1'!$B:$B='Sheet2'!$B2, 'Sheet1'!$D:$D))}

thus i thought a counta formula should work:

{=CountA(IF('Sheet1'!$B:$B='Sheet2'!$B2, 'Sheet1'!$C:$C))}

But it doesn't, it just counts everything. What am I doing wrong?

Hiya! Lets just say that i can't make use of pivot tables, for other reasons. Any ideas why my array formula doesn't work?

Nevermind, I just tested your solution, works brilliantly! Thank you!