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

Sespedido_23

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.

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!