Using MAX with SUMIFS

No. You just need to list the whole 30 column range in the last part.

e.g.

=MAX(IF(($A$2:$A$100=Building)*($B$2:$B$100=Cost Cente),$C$2:$AD$100))

just remember to hold the CTRL+SHIFT keys down and hit ENTER to confirm it.

Edit: Sorry, I think daddylonglegs' is better... mine assumes there is one number in each column that might match, not the sums....