Conditional count of parents rows only with now children on a date column.

Help!

I have this formula on a different sheet that works when I am counting the dates in the column. However, I want to count only the parent deliverables, not the children’s tasks. Can someone please help me?

=COUNTIFS({CC Label Activities}, AND(@cell >= DATE(year@row, [Month1]@row, 1), @cell <= DATE(year@row, [Month1]@row, 31)))

Sample Data Sheet

Sample Formula sheet

Thank you!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Kingskid

Ah my apologies! I skipped over the AND in your COUNTIFS. You don't need this as the COUNTIFS is already an AND statement.

Try:

=COUNTIFS({Date Logged}, <> "", {CC Label Activities}, >= DATE(year@row, [Month1]@row, 1), {CC Label Activities}, <= DATE(year@row, [Month1]@row, 31))

Let me know if this gives you an error or incorrect result.

Genevieve P.

Hi @Kingskid

Since we removed the AND(), you only need 2 )) at the end of the formula. Try removing out one of the ) and see if that helps. 🙂

All comments

Genevieve P.

Hi @Kingskid

You can filter out Child Rows as long as your source sheet has something that indicates if the row is a Child or Parent.

From what I can see in your screen capture, only Parent rows have a date in the "Date Logged" column, is that correct? If so, you can add criteria that says that cell needs to be <> "" or Not Blank:

=COUNTIFS({Date Logged Column}, <> "", {CC Label Activities}, AND(@cell >= DATE(year@row, [Month1]@row, 1), @cell <= DATE(year@row, [Month1]@row, 31)))

Cheers,

Genevieve

Kingskid

Hi @Genevieve P. ,

Thank you for being so helpful.

Please see the image below.

Thank you!

Genevieve P.

Hi @Kingskid

Ah my apologies! I skipped over the AND in your COUNTIFS. You don't need this as the COUNTIFS is already an AND statement.

Try:

=COUNTIFS({Date Logged}, <> "", {CC Label Activities}, >= DATE(year@row, [Month1]@row, 1), {CC Label Activities}, <= DATE(year@row, [Month1]@row, 31))

Let me know if this gives you an error or incorrect result.

Kingskid

Hi @Genevieve P.

Sorry but I am getting the error below. I tried to play around with it, but I still get errors.

Thank you for your time.

Genevieve P.

Hi @Kingskid

Since we removed the AND(), you only need 2 )) at the end of the formula. Try removing out one of the ) and see if that helps. 🙂

Kingskid

Hi @Genevieve P. ,

Thanks a million for your help! I appreciate it!

It worked! 😂

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.