If you are saying there is a cell in Sheet1 with the Y in it, use

=SUMIF(B:B,Sheet1!H1,C:C)


--
__________________________________
HTH

Bob

"MichelleT" wrote in message
...
How does the formula identify whether text in column B is Y/N when the
formula does not make any reference to sheet 1

"Sam Wilson" wrote:

=SUMIF(B:B,"Y",C:C)

Ignore the last one with the typo

"MichelleT" wrote:

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