Count IF formula

Hello,

I am trying to find the formula to use to count the number of rows assigned to an email are on a data sheet and will need counts specific for each month. Which I will adjust the formula for all the other columns months. Below I have how to pull for the user email but not sure how to add in the argument for the date/month.

The date column on the data sheet is a created date column.

=COUNTIF([User Email]@row, {BI Invoicing Errors Range 1}

Thank you for your help!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Nic Larsen

Try something like this:

=COUNTIFS([User Email]@row, {BI Invoicing Errors Range 1}, {Date Column Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2019))

In this one it is counting the ones in Month January (1) and year 2019. Update to your needs

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.