Countifs Formulas

Good Morning,

I am trying to count if someone was promoted in 2020-2021 which has a Check box column or TRUE, as well as their rank. The formula is populating 0 so I must be doing something wrong? For instance we promoted 10 people to Associate Professor, 8 of which are female & 2 male.

=COUNTIFS({All Faculty List Range 3}, "true", {All Faculty List Range 4}, "Associate Professor")

Appreciate your help!

Thanks,

Liz

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this:

=COUNTIFS({All Faculty List Range 3}, @cell = 1, {All Faculty List Range 4}, "Associate Professor")

Elizabeth Anderson

@Paul Newcome thank you so that's working but the output is wrong there should be 5 not 10 my apologies & it's populating 33?

Paul Newcome

Try applying a filter to the source sheet that matches the same criteria and see how many rows come up.

Elizabeth Anderson

@Paul Newcome yes I did that and that's when i noticed that 5 people should be populating not 33-any ideas?

Paul Newcome

Are you able to provide some screenshots? Names can be hidden so long as we can see the two ranges being evaluated?

Elizabeth Anderson

@Paul Newcome Please note I am working on the child rows for 20-21

Paul Newcome

My apologies. I meant of the source data.

Elizabeth Anderson

@Paul Newcome

ahhh i see thank you for clarifying!

Paul Newcome

I am assuming Range 4 is the [Current Rank] column. What is Range 3?

Elizabeth Anderson

@Paul Newcome my apologies for the delay!

List Range 3= Promoted in 2020-2021 & its a Checkbox

Lis Range 4= Current Rank

Paul Newcome

The data in your screenshot doesn't show any checkboxes actually being checked there in the 2020-2021 column.

Elizabeth Anderson

@Paul Newcome the screen shot does not correct however there are 377 rows 18 or which are checked:

Paul Newcome

Hmm... Did we double check the spelling already? If you have (for example) 50 spaces between two words, it will still only display as a single space, but it will not provide a match if you were searching for a single space between the two words. How is the [Current Rank] column populated?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.