COUNTIFS 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.

How to Calculate Ratios in Excel

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

Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios, you need to calculate the highest common factor. You can easily do this with the GCD function.

The post How to Calculate Ratios in Excel 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.

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.