SUMIFS Archives - Xelplus - Leila Gharani

How to Use Excel SUMIFS on Multiple Criteria in a Single Column

Leila Gharani — Thu, 26 Aug 2021 06:49:00 +0000

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.

Best 10 Excel Functions for Accountants

Leila Gharani — Thu, 25 Feb 2021 10:00:00 +0000

Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

Excel LAMBDA Function Explained

Leila Gharani — Thu, 17 Dec 2020 10:00:00 +0000

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 1, discover the LAMBDA logic and learn how to write your first Lambda.

The post Excel LAMBDA Function Explained appeared first on Xelplus - Leila Gharani.

Excel Function to Check IF a Cell Contains Specific Text

Leila Gharani — Sat, 01 Jun 2019 22:31:00 +0000

How can you use wildcards in Excel's IF Function - with this method you can easily check for a partial text match. It's a clever method to get the IF function to check if the cell value contains a word.

The post Excel Function to Check IF a Cell Contains Specific Text appeared first on Xelplus - Leila Gharani.

Excel SUM based on Partial Text Match (SUMIFS with wildcards)

Leila Gharani — Wed, 28 Nov 2018 21:22:00 +0000

SUMIFS is great for summing values based on a condition. But did you know you can also sum values based on a partial text match? Find out more in this post.

The post Excel SUM based on Partial Text Match (SUMIFS with wildcards) appeared first on Xelplus - Leila Gharani.

Excel SUM Between Dates

Leila Gharani — Fri, 27 Jul 2018 17:45:00 +0000

Excel's SUMIFS function makes it super easy to sum values that fall between two dates. You'll also learn how to sum by month and also add in multiple criteria.

The post Excel SUM Between Dates appeared first on Xelplus - Leila Gharani.

Excel Dynamic Map with Drop-Down

Leila Gharani — Sun, 28 Jan 2018 21:41:00 +0000

In case you're interested to visualize a KPI on a customized map in Excel which works on any version of Excel, then this tutorial is for you. I show you in easy steps how to find the right map and how to set it up properly.

The post Excel Dynamic Map with Drop-Down appeared first on Xelplus - Leila Gharani.

Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header

Leila Gharani — Fri, 21 Apr 2017 05:08:00 +0000

In this video tutorial, you will learn how to sum different columns based on user selection with the SUMIFS or SUMPRODUCT function. It's a useful technique for interactive dashboards.

The post Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header appeared first on Xelplus - Leila Gharani.

Excel INDIRECT Function

Leila Gharani — Tue, 28 Mar 2017 11:51:00 +0000

The INDIRECT() function comes very handy when need to feed different ranges to certain formulas, especially when you refer to ranges in other sheets. This tutorial explains how the INDIRECT() function works and how to use in a real-life scenario, gathering data from different tabs.

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

Lookup Within Boundaries

Leila Gharani — Sun, 12 Feb 2017 10:20:00 +0000

This tutorial takes you through three powerful Excel formulas that lookup values in ranges that include lower bound and upper bound values. They are SUMIFS, SUMPRODUCT and INDEX/MATCH. Find the one that works best for your scenario.

The post Lookup Within Boundaries appeared first on Xelplus - Leila Gharani.