Looking for help with countif formula

I'm having some trouble with a countif formula, looking for some assistance.

My goal here is to count the number of time the Created Date is last month and that the service type is "Trade Database - Add Part Number(s)"

When I enter the formula below it works great!

=IF(MONTH(TODAY()) = 1, COUNTIFS({Genie Archive Created Date}, IFERROR(MONTH(@cell), 0) = 12, {Genie Archive Created Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1), COUNTIFS({Genie Archive Created Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()) - 1, {Genie Archive Created Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))), {Genie Archive Service Type}, "Trade Database - Add Part Number(s)"

I now need to add the following to the above

{Genie Archive Service Type}, "Trade Database - Add Part Number(s)"

I tied the two of them together as follows:

When I do I get an UNPARSABLE error message.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this one...

=COUNTIFS({Genie Archive Service Type}, "Trade Database - Add Part Number(s)", {Genie Archive Created Date}, AND(IFERROR(MONTH(@cell), 0) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - IF(MONTH(TODAY()) = 1, 1)))

All comments

Jason Albrecht

Hi JP

If I've counted the brackets correctly, I think one of the closing brackets after the last TODAY function needs to be deleted.

e.g., try replacing YEAR(TODAY()))) with YEAR(TODAY())) and see how that goes?

JP Pedicino

Unfortunately not the solution

Paul Newcome

Try this one...

JP Pedicino

Thank you Paul!

I have so much to learn yet, but excited to do so. You and the others have been an amazing asset in this community.

Paul Newcome

Happy to help. 👍️

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.