<div>
Sumifs etc. can not handle more than one column for the values, so some extra columns for Sum, Min and Max must be added.<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559196/test-sum-min-max.xlsx" rel="ugc">test sum-min-max.xlsx</a>
</div>


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 [https://filedb.experts-exchange.com/incoming/2021/05_w19/1559196/test-sum-min-max.xlsx]

test-sum-min-max.xlsx

<div>
Well, sumifs do not support multi columns, but there is a workaround:<br>Sum each row in an additional column, and perform a sumifs on it.<br><br>See the attached workbook.<br><br>&nbsp;<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559197/test.xlsx" rel="ugc">test.xlsx</a>
</div>


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 [https://filedb.experts-exchange.com/incoming/2021/05_w19/1559197/test.xlsx]

test.xlsx

Tom M

<div>
<div class="content wysiwyg-content fr-view">
I am not sure what I am doing wrong with my if statements in the attached spreadsheet. &nbsp;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. &nbsp;I am then looking to pull the min and max from the same data range whenever c1 equals AA in sheet 1<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559168/test.xlsx" rel="ugc">test.xlsx</a>
</div>
</div>



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

Sumif statement error

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.