On sheet1 you should use separate cells for the number and letter:

......A.....B.....C
1...1.....Y.....20

Enter this formula in C1:

=SUMPRODUCT(--(Sheet2!A$1:A$4=A1),--(Sheet2!B$1:B$4=B1),Sheet2!C$1:C$4)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"bokey" wrote in message
...
Hi,
I have two worksheets and need to show the totals on worksheet 1 when the
criteria from worksheet 2 are met. For instance, on worksheet 2, when
column
A = 1 and column B = Y, then sum C. In this example, the amount I expect
on
worksheet 1 is 20.00

Worksheet 1
A B
1Y $20.00
1N $10.00
2Y $10.00
2N $0

Worksheet 2
A B C
1 Y 10.00
1 N 10.00
2 Y 10.00
1 Y 10.00