Just to be completely clear:

If you meant column A literally contains the letter X and column B literally
contains the letter Y

=sumproduct(--(A1:A200="X"),--(B1:B200="Y"),C1:C200)

--
Regards,
Tom Ogilvy

Tom Ogilvy wrote in message
...
=sumproduct(--(A1:A200=X),--(B1:B200=Y),C1:C200)

--
Regards,
Tom Ogilvy

"Frankyboy" wrote in message
. ..
I need to combine 2 SUM-IF but Excel says that it is not possible

What I need to do is to get the sum of column C if the value of column A
is
X and the value of column B is Y

Can someone help me with that?

Frank