SUM Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sum/ Bestselling Excel and Power BI Courses Thu, 09 Mar 2023 09:34:10 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SUM Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sum/ 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.

]]> What are Excel 3-D Formulas and How Can You Create One? https://www.xelplus.com/excel-3d-formulas/ Thu, 23 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11553 With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.

The post What are Excel 3-D Formulas and How Can You Create One? appeared first on Xelplus - Leila Gharani.

]]> Excel SUMPRODUCT – Calculate Year To Date https://www.xelplus.com/sumproduct-year-to-date/ Wed, 30 Nov 2016 10:27:00 +0000 https://www.xelplus.com/?p=13085 Learn how to write dynamic YTD formulas in Excel using SUMPRODUCT, OFFSET & SUM functions, even when your data set goes over a few years, with each month occurring more than once.

The post Excel SUMPRODUCT – Calculate Year To Date appeared first on Xelplus - Leila Gharani.

]]>