Calculation and IF Together

[netclick]

I am new to excel and need an experts help on a simple formula

I want to add the total of B21:B30 and if it is less than the value of C21:C30 then
Display "Team 2 Win" and vice versa.

Team 1 is the B Column
Team 2 is the C Column

This is what I got:
=SUMIF((B21:B30>C21:C30),"Team 1 Win","Team 2 Win")

Was I way off? BTW I am using Excel 2003.

thanks in advance!
Ben

[Jeff Italy]

You have to edit the sum function "inside" the formula:
if(sum(a1:a30)>sum(B1:b30);"A win";"B win")

[netclick]

Thanyou Jeff for your help~!

[daddylonglegs]

What if they're the same?

[netclick]

Good Question! I didn't think of that!

[daddylonglegs]

You could use this formula

=IF(COUNT(B21:C30),CHOOSE(SIGN(SUM(C21:C30)-SUM(B21:B30))+2,"Team 1 Win","Tie","Team 2 Win"),"")

It only shows "Tie" when scores are level but there's at least one value -