Trying to use Counta but only if another column = x

I currently have =COUNTA(Attendance!C:C) to count entries and show how many people are here today.

This counts everyone here but I need to only count for a specific department so it should only count if the same row column B = X.

I would think this would be easy but the solution eludes me.

Hi Feril,

Use =COUNTIF(Attendance!B:C, "X")

tnx tnx

Jarvin24 yours doesn't work at all. I have 21 people in column a, 11 with X in column b and not all eleven were here so column C was blank for 2. That means it should return 8 and it returned 15.

Column A name, b department, c checkmark if they are here blank if absent.

bebo021999 I am trying to understand yours can you break it down for me?

IT works as =COUNTIFS(Attendance!B:B,"X",Attendance!C:C,"<>"&"")

I understand if b = x then return Attendance!C:C

but what are the <> and & for?

Ok thanks that's what I was missing as I was actually trying to do that but couldn't get the syntax right. Thanks a bunch!