Intent: Collect the amount of Non-Billed Payments for a specific timeframe if the payment type is 5.

*** Definitions: Separate Metrics sheet used to collect the following -- > 

Sheet/Column {Non-Billed Payments Date Paid} is a date field in a referenced sheet

[Range Start] [Range End} are date fields for the first and last day of the billing period for the entire year in the sheet that contains the formula

Sheet/Column {Non-Billed Payment Amount} is the amount in the referenced sheet

Sheet/Column {Non-Billed Payment Type} contains the last criteria in the referenced sheet

*** This works:

=SUMIF({Non-Billed Payments Date Paid}, AND(@cell >= [Range Start]32, @cell <= [Range End]32), {Non-Billed Payment Amount})

*** This doesn't work (#UNPARSEABLE), some simple syntax error that I can't spot.

=SUMIF({Non-Billed Payments Date Paid}, AND(@cell >= [Range Start]32, @cell <= [Range End]32), {Non-Billed Payment Type} "5", {Non-Billed Payment Amount})

I also tried

=SUMIF@({Non-Billed Payments Date Paid}, AND(@cell >= [Range Start]32, @cell <= [Range End]32), {Non-Billed Payment Type} "5", {Non-Billed Payment Amount})

=SUMIF({Non-Billed Payments Date Paid}, AND(@cell >= [Range Start]32, @cell <= [Range End]32), AND{Non-Billed Payment Type} "5", {Non-Billed Payment Amount})

--Thanks in advance!