Adding SUMIFS then Divide

[zero269]

Hello,

I'm having an issue with adding two SUMIFS results to get an accurate percentage.

I built my overall formula using a few steps. The individual SUMIFS turn out perfect. However, when trying to combine everything, the percentages are incorrect.

Test Columns 4 & 5 show vastly different percentages. Column 4 is correct.

Test Column 1 (Points to Date) using formula which sums up the earned Points for Student1 within a date range and produces the correct values.

=SUMIFS(Student1[Points],Student1[Test Date],">="&$C$14,Student1[Test Date],"<="&$C18)

Test Column 2 (AR Points) using formula which sums up the potential AR Points for Student1 within a date range, and where the Score value is empty, and produces the correct values.

=SUMIFS(Student1[AR Points],Student1[Test Date],">="&$C$14,Student1[Test Date],"<="&$C18,Student1[Score],"="&"")

Test Column 3 (Total Points) just sums the above two values from 1 & 2 and produces the correct results.

=SUM(R18:S18)

Test Column 4 (Short %) just divides Column 3 by 14 (cell $B$14) and produces the correct results.

=T18/$B$14

Test Column 5 (Long %) is my failed attempt at combining/adding the formulas from 1 & 2 together and then dividing it by 14 located in cell $B$14.

=SUMIFS(Student1[Points],Student1[Test Date],">="&$C$14,Student1[Test Date],"<="&$C18)+SUMIFS(Student1[AR Points],Student1[Test Date],">="&$C$14,Student1[Test Date],"<="&$C18,Student1[Score],"="&"")/14

I even tried a few variations of enclosing the SUMIFS with parenthesis, but that had no effect on the currently incorrect results.
=SUMIFS+(SUMIFS)/14
=(SUMIFS)+SUMIFS/14
=(SUMIFS)+(SUMIFS)/14

If I just add the two SUMIFS without dividing the results by 14, I get the correct sum of points seen in Test Column 3:
=SUMIFS(formula)+SUMIFS(formula)

Once I try dividing by 14, all hell breaks loose…

Any help deciphering my mistake would be greatly appreciated…

 

[zero269]

Disregard my request...
I just tried the following and it worked:
=((SUMIFS)+(SUMIFS))/14