To answer your question above, the max will consist of numbers from a single column....not the sum in each row where criteria is met.

I will try what you've recommended... so far, I tried using

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

And it's giving me the #NAME! error