For pull in the Amount of the invoice into column H:
In cell H5, I typed in =SUMIFS(C1:C11,A1:A11,A2).
In cell H6, I typed in =SUMIFS(C1:C11,A1:A11,A3).
In cell H7, I typed in =SUMIFS(C1:C11,A1:A11,A4).

For total value of all invoices:
In cell H8, I typed in =SUM(H5:H7). That gives a total of 1059.

Paula, am I doing it right? I hope that I'm doing it right.