Using MAX with SUMIFS

[michaelweaver4]

Hi All,

I am trying to get the max of several data points. I'll explain. I'm looking at three columns..

1. Building
2. Cost Center
3. Number Values for 'x'

On a different worksheet, I want to SUM the Number Values Column IF it meets 'y' Building AND 'z' Cost Center.

Here's the twist. There are a total of 30 columns of number values to sum. Using the criteria above, in one formula, I want to get the MAX of the 30 sums that meet the criteria.

Right now, I have a formula that is not working...

=MAX(SUMIFS(Number Value Range to sum 1, Building Column, Building, Cost Center Column, Cost Center),(Number Value Range to sum 2, Building Column, Building, Cost Center Column, Cost Center),(Number Value Range to sum 3, Building Column, Building, Cost Center Column, Cost Center), etc.....