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