Array Formulas Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/array-formulas/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 00:49:05 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Array Formulas Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/array-formulas/ 32 32 How to Use Excel SUMIFS on Multiple Criteria in a Single Column https://www.xelplus.com/sumifs-multiple-criteria-in-a-single-column/ Thu, 26 Aug 2021 06:49:00 +0000 https://www.xelplus.com/?p=9844 Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.

The post How to Use Excel SUMIFS on Multiple Criteria in a Single Column appeared first on Xelplus - Leila Gharani.

]]> Excel Lookup Multiple Criteria in Rows or Columns https://www.xelplus.com/excel-index-and-match-2/ Thu, 17 Aug 2017 22:18:00 +0000 https://www.xelplus.com/?p=11994 Learn how to perform a matrix lookup, i.e. when you need to return the value based on the header row and the category column, in a scenario where you have more than one header. The powerful INDEX/MATCH combo is capable of handling that a couple of ways.

The post Excel Lookup Multiple Criteria in Rows or Columns appeared first on Xelplus - Leila Gharani.

]]> Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3) https://www.xelplus.com/excel-array-formulas-count-unique-items-mmult-indirect-row-functions/ Wed, 01 Feb 2017 09:10:00 +0000 https://www.xelplus.com/?p=12680 Consider a scenario, where you need to return a unique count across rows rather than column. You could use the TRANSPOSE function, but in older versions of Excel, TRANSPOSE requires pressing Control Shift Enter (CSE). If you'd rather avoid it, but keep the solution dynamic, you need to look for an alternative. In this tutorial, you will find 3 different solutions based around the ROW function - in combination with INDIRECT, INDIRECT & ADDRESS, and INDEX.

The post Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3) appeared first on Xelplus - Leila Gharani.

]]> Excel Arrays: Count Unique Items with MMULT Function (Part 2/3) https://www.xelplus.com/excel-arrays-count-unique-items-with-mmult-function/ Mon, 23 Jan 2017 15:45:00 +0000 https://www.xelplus.com/?p=12705 Learn how to get the unique count across rows using an array formula based on the MMULT and SUMPRODUCT functions.

The post Excel Arrays: Count Unique Items with MMULT Function (Part 2/3) appeared first on Xelplus - Leila Gharani.

]]> 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) https://www.xelplus.com/excel-array-formula-unique-count-rows-excel-part1/ Thu, 19 Jan 2017 08:11:00 +0000 https://www.xelplus.com/?p=12721 Learn how to get the unique count across rows using an array formula based on the SUMPRODUCT and FREQUENCY functions.

The post 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) appeared first on Xelplus - Leila Gharani.

]]>