multiple criteria Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/multiple-criteria/ Bestselling Excel and Power BI Courses Tue, 19 Nov 2024 06:34:13 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png multiple criteria Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/multiple-criteria/ 32 32 COUNTIFS Function in Excel https://www.xelplus.com/excel-countifs-function/ Wed, 05 Jun 2024 06:22:14 +0000 https://www.xelplus.com/?p=24151 Master the COUNTIFS function in Excel. Count cells based on multiple criteria with this powerful tool. Free practice file included.

The post COUNTIFS Function in Excel appeared first on Xelplus - Leila Gharani.

]]> How To Use Excel FILTER Function With Multiple Criteria https://www.xelplus.com/excel-filter-function-with-multiple-criteria/ Thu, 24 Aug 2023 15:02:59 +0000 https://www.xelplus.com/?p=17612 Learn to use Excel's FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

The post How To Use Excel FILTER Function With Multiple Criteria appeared first on Xelplus - Leila Gharani.

]]> INDEX MATCH 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 INDEX MATCH Multiple Criteria in Rows or Columns appeared first on Xelplus - Leila Gharani.

]]>