sumproduct subtotal combo?

edit:

Adding on to yesterday's question, I have added another column:

[inputcell: A1] = 1000

[B]....[C]....[D]
1000...$10...YES
2000...$20...NO
2001...$30...YES
1000...$15...MAYBE
1000...$8...MAYBE

how do i sum the Yes/No/Maybe values based on A1?

answer: Yes -10, No-0, Maybe-23 for A1=1000 (these answers can be in 3 diff cells)