SUMIFS and #VALUE! error

[BDAtlanta]

I can't seem to get this formula to work. Can anyone see what it is i'm doing wrong?

The formula is:
=SUMIFS(TablePrice[NewPrice],H6,TablePrice[Tier],H7,TablePrice[Term],H5,TablePrice[PublicationID])

The file is attached. I appreciate the help.

[teylyn]

You have the order of the parameters wrong

Sumifs(sumrange, criteria range 1, criterion 1, criteria range 2, criterion 2, ....)

=SUMIFS(TablePrice[NewPrice],TablePrice[Tier],H6,TablePrice[Term],H7,TablePrice[PublicationID],H5)

[martindwilson]

syntax looks wrong in sumifs the range to be summed is first followed by the conditional ones
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,
criteria2], …)

[BDAtlanta]

You have the order of the parameters wrong

Sumifs(sumrange, criteria range 1, criterion 1, criteria range 2, criterion 2, ....)

=SUMIFS(TablePrice[NewPrice],TablePrice[Tier],H6,TablePrice[Term],H7,TablePrice[PublicationID],H5)

Oh, wow. I just knew it was something like that. Thanks guys!