Sumif statement error

I am not sure what I am doing wrong with my if statements in the attached spreadsheet. On the summary tab I have 3 formula, I am looking to sum sheet l all data in range B:Y whenever sheet l column aa equals summary cell C1. I am then looking to pull the min and max from the same data range whenever c1 equals AA in sheet 1
test.xlsx

Microsoft ExcelMicrosoft Office

Last Comment

Norie

8/22/2022 - Mon

Ejgil Hedegaard

5/3/2021

Sumifs etc. can not handle more than one column for the values, so some extra columns for Sum, Min and Max must be added.
test sum-min-max.xlsx

Fabrice Lambert

5/3/2021

Well, sumifs do not support multi columns, but there is a workaround:
Sum each row in an additional column, and perform a sumifs on it.

See the attached workbook.

test.xlsx

ASKER CERTIFIED SOLUTION

Norie

5/3/2021

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.