COUNTIFS QUESTION

I need to count a contract only if the date when it was reviewed was during Q2 , but the contract can be review several times, so in my database I have a date column for every time I had to reviewed it. So I need a formula that count if revision date 1 its in Q2, but also if revision date 2 its in Q2.

Q2 its between : DATE(2021, 8, 1) DATE(2021, 10, 31)

Currently using this but is not working yet:

=COUNTIFS([Fecha Respuesta Legal 1]@row:[Fecha Respuesta Legal 1]@row, >=DATE(2021, 8, 1), [Fecha Respuesta Legal 1]@row:[Fecha Respuesta Legal 1]@row, <=DATE(2021, 10, 31))+COUNTIFS ([Fecha respuesta Legal 2]@row:[Fecha respuesta Legal 2]@row, >=DATE(2021, 8, 1), [Fecha respuesta Legal 2]@row:[Fecha respuesta Legal 2]@row, <=DATE(2021, 10, 31))

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hello @Kathe

Your formula was on track - you have a syntax error when writing your ranges.

=COUNTIFS([Fecha Respuesta Legal 1]:[Fecha Respuesta Legal 1], >=DATE(2021, 8, 1), [Fecha Respuesta Legal 1]:[Fecha Respuesta Legal 1], <=DATE(2021, 10, 31))+COUNTIFS ([Fecha respuesta Legal 2]:[Fecha respuesta Legal 2], >=DATE(2021, 8, 1), [Fecha respuesta Legal 2]:[Fecha respuesta Legal 2], <=DATE(2021, 10, 31))

Kelly

Kathe

Hello Kelly,

Actually the ranges are correct, because when I divided the formula and included only the first part it is working: =COUNTIFS([Fecha Respuesta Legal 1]@row:[Fecha Respuesta Legal 1]@row, >=DATE(2021, 8, 1), [Fecha Respuesta Legal 1]@row:[Fecha Respuesta Legal 1]@row, <=DATE(2021, 10, 31))

I think the problem is with the second part with the +COUNTIFS.....

Kelly Moore

Hey @Kathe

I'm sorry - somehow your response was lost until just now. And you're right - I don't see now in the ranges what I thought I saw then. Did you get this working?

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.