Ctrl+Shift+Enter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/ctrlshiftenter/ Bestselling Excel and Power BI Courses Wed, 01 Mar 2023 22:34:21 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Ctrl+Shift+Enter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/ctrlshiftenter/ 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.

]]>