I have a scoresheet I am trying to compile for someone. I ran it through like
it was a real time match and these are the results. This is what I have right
now.

In B5 I have 'Team #1'
And in C5 I have 'Team #2'

Team #1
(AA12:AB12) 150
(AA13:AB13) 30
(AA14:AB14) 20

Team #2
(AA24:AB24) 70
(AA25:AB25) 60
(AA26:AB26) -10
(AA27:AB27) 20
(AA28:AB28) 10

In AA16:AB16 I have the SUM of AA12:AB14
In AA30:AB30 I have the SUM of AA24:AB28

I need the results to appear like this

A38 B38 C38
1st place team Team #1 190

A39 B39 C39
2nd place team Team #2 150

Right now I have C38 as =MAXA(AA16, AA30)
And C39 as =MIN(AA16, AA30)

But in B38 I would like the text 'Team #1' to automatically appear when C38
has the higher amount. And in B39 I would also like the text 'Team #2' to
appear automatically when C39 has the lower amount.

Can anybody help me or is this just too hard?