e.g total for x is only 25 and not 45 because a & b = Y and C = N in sheet 1
Hope eg explains better

sheet 2
A B C
1 x a 10
2 x b 15
3 y c 18
4 x c 20

"Ashish Mathur" wrote:

Hi,

Your question is not clear. Anyway, try this

=sumproduct((sheet2!A1:A3=B1)*(sheet2!B1:B3=A1)*(s heet2!C1:C3))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MichelleT" wrote in message
...
Hi, can someone help me with the formula to get the total of column C in
sheet 2 if column B in sheet 2 is Y (reference to sheet 1)

sheet 1
A B
1 a Y
2 b Y
3 c N

sheet 2
A B C
1 x a 10
2 x b 15
3 y c 18


thanks
Michelle