SUM using 2 lookup values

[GoGoeGo]

I am looking for a way to look up 2 reference points (in the example: house # and order #) and return the value (price). Please see the example I've attached.

Thanks ahead of time for any and all suggestions!

[alansidman]

In G2 =SUMIFS($C$3:$C$9,$B$3:$B$9,G$2,$A$3:$A$9,$F3)

Copy over and down

[José Augusto]

Use in G3 and drag down and right

Please Login or Register  to view this content.

[GoGoeGo]

Perfect, thank you so much!