Count a Checkbox and a value

Question

Hi there

I have a sheet that inidcates the level of a student and whether they have secured an internship. The first value is their academic level and the second value is a simple checkbox.

I am trying to count them but not getting very far - I can count the number of checkboxs and I can count the number based on level but I need the two together:

=COUNTIFS({2021/2022 Student Engagement Master Range 2}, 1 - this is the checkbox

=COUNTIFS({2021/2022 Student Engagement Master Range 4}, "4" - this is the one that count the level of the student.

So how can I meld them together so it tells me a value based on what level they are and whether they have an internship?

Thanks

Blayne

Kevin Smith · Accepted Answer

Hi,

If you are looking for a count of rows that have both a check box checked AND a '4' in a col. you would do this:

=COUNTIFS({Range of the checkbox}, = 1, {Range of the level}, =4)

If 4 is actually text, you will need "" around it.

Please let me know if that doesn't work for you.