COUNTIFS using two fields

Tmaid

This is my formula

=COUNTIF(([Restack Required]7:[Restack Required]370, "Y"), Site:Site, = "1")

I'm getting the correct response is I have separated out as shown below:

=COUNTIF(Site:Site, "1")- This column is a checkbox

=COUNTIF([Restack Required]7:[Restack Required]370, "Y")

But putting them together I get #UNPARSEABLE

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

Give this a try:

=COUNTIFS(Site:Site, "1", [Restack Required]7:[Restack Required]370, "Y")

Tmaid

it came back with #incorrect argument set

I had to edit it to this and it worked

=COUNTIFS(Site7:Site370, "1", [Restack Required]7:[Restack Required]370, "Y")

THANK YOU!

Carson Penticuff

I didn't even catch it before. Is there a reason you are only looking at rows 7-370 in the second statement?

Site:Site will look at the entire Site column, while [Restack Required]7:[Restack Required]370 will only look at rows 7-370. Since you are evaluating values in two different columns, they will need to be the same. Also, if you specify row 370, there must be at least 370 rows in the sheet or you will receive an error. You will want one of these options:

=COUNTIFS([Site]:[Site], "1", [Restack Required]:[Restack Required], "Y")

=COUNTIFS([Site]7:[Site]370, "1", [Restack Required]7:[Restack Required]370, "Y")

Tmaid

I was hoping to use the full column in the formula but I am creating sums at the bottom of the sheet and right under the "Restack Required" data. So I wanted to limit what it was looking at.

Carson Penticuff

The last formula should work for you then. Just modify the row numbers if you need something slightly different. If you really want to use the entire columns, you could always move your sums to a different column.

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.