Need to know what's causing the incorrect value shown after formula is created

I'm trying to count all rows that are tagged as "4. Billing Adjustments" within the current year from "Date Submitted" column also tagged as "Credit" from "Type of Change Requested" column but not getting the correct result

=COUNTIFS([Attrition Stage**]:[Attrition Stage**], "4. Billing Adjustments", [Type of Change Requested]:[Type of Change Requested], "Credit") + COUNTIFS([Attrition Stage**]:[Attrition Stage**], "4. Billing Adjustments", [Date Submitted]:[Date Submitted], @cell >= DATE(YEAR(TODAY()), 1, 1), [Date Submitted]:[Date Submitted], @cell <= DATE(YEAR(TODAY()), 12, 31))

Hope you can help me improve my formula, thank you.

Find more posts tagged with

Accepted answers

All comments

heyjay

Are you trying to get the sum of this,

=COUNTIFS(
[Attrition Stage**]:[Attrition Stage**], "4. Billing Adjustments",
[Type of Change Requested]:[Type of Change Requested], "Credit")

and this?

=COUNTIFS(
[Attrition Stage**]:[Attrition Stage**], "4. Billing Adjustments",
[Date Submitted]:[Date Submitted], @cell >= DATE(YEAR(TODAY()), 1, 1),
[Date Submitted]:[Date Submitted], @cell <= DATE(YEAR(TODAY()), 12, 31))

Or just wanting to get the count of all 4 criteria like this?

=COUNTIFS(

[Attrition Stage**]:[Attrition Stage**], "4. Billing Adjustments",

[Type of Change Requested]:[Type of Change Requested], "Credit",

[Date Submitted]:[Date Submitted], @cell >= DATE(YEAR(TODAY()), 1, 1),

[Date Submitted]:[Date Submitted], @cell <= DATE(YEAR(TODAY()), 12, 31))

Sespedido_23

I figured the correct formula and the 3rd example you shared is the one I used.

Thank you for the response, I appreciate it!

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.