COUNTIFS 2 sheets, 2 columns each?

I have this formula that pulls all requests for February (well, every month, but lets start with February) from 2 sheets. But now I need it to also only pull the count for only the items that are also considered from "meetings" under the "type" column. Basically answering the question: how many of these line items happened in february and came from meetings?

This formula works but doesn't filter by type:

=COUNTIF([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2) + COUNTIF({Completed Follow Ups Range 1}, IFERROR(MONTH(@cell), 0) = 2)

This one doesn't work but shows what I'm trying to do, but it doesn't work, any ideas what I'm doing wrong?

=COUNTIFS ([Request Date]:[Request Date],[type]:[type], FIND("meeting", @cell) IFERROR(MONTH(@cell), 0) = 2) + COUNTIF({Completed Follow Ups Range 1}, IFERROR(MONTH(@cell), 0) = 2)

Find more posts tagged with

Accepted answers

Jake Gustafson

I'm not sure I"m following completely, but couldn't you do your COUNTIFS like this:

Parameter 1 = month (i.e., February)

Parameter 2 = type (i.e., Meetings)

=COUNTIFS([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2, Type:Type, "Meeting") then add in your second sheet using the cell reference and probably doing COUNTIFS again

All comments

Jake Gustafson

I'm not sure I"m following completely, but couldn't you do your COUNTIFS like this:

Parameter 1 = month (i.e., February)

Parameter 2 = type (i.e., Meetings)

=COUNTIFS([Request Date]:[Request Date], IFERROR(MONTH(@cell), 0) = 2, Type:Type, "Meeting") then add in your second sheet using the cell reference and probably doing COUNTIFS again

COSM.Kayla

that worked!! I have no idea how I was messing that up so badly but thank you!!

Jake Gustafson

Glad to hear. Sometimes you just need to talk it out. A great start to your week. Go get 'em!

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.