wildcards Archives - Xelplus - Leila Gharani

COUNTIFS Function in Excel

Leila Gharani — Wed, 05 Jun 2024 06:22:14 +0000

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.

Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks)

Leila Gharani — Thu, 05 Mar 2020 10:00:00 +0000

Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

How to Use Excel XLOOKUP Function – 5 Examples

Leila Gharani — Thu, 28 Nov 2019 10:00:00 +0000

Excel's New & Improved XLOOKUP function will be the answer to most of your Excel Lookup problems. Learn from these 5 examples to see how you can apply the new XLOOKUP function to your files.

The post How to Use Excel XLOOKUP Function – 5 Examples appeared first on Xelplus - Leila Gharani.

Excel Function to Check IF 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 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.

VBA DIR: Check If File or Folder Exists

Leila Gharani — Thu, 22 Nov 2018 15:18:00 +0000

Discover how the DIR function works in VBA. It returns a string that represents a directory or file that matches a defined pattern. This is helpful when you need to refer to other files or folders in your macro. You can also check if a folder exists, and if it doesn’t, create a new folder in the directory.

The post VBA DIR: Check If File or Folder Exists appeared first on Xelplus - Leila Gharani.

Excel SUMIFS Function

Leila Gharani — Fri, 10 Feb 2017 14:06:00 +0000

Learn how to use the SUMIFS function in Excel to sum values based on multiple conditions. Free practice file included.

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