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

SUMIFS, COUNTIFS & AVERAGEIFS

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

Learn how to use the conditional aggregation functions: SUMIFS, AVERAGEIFS, COUNTIFS. You don't need to waste time copying filtered ranges, you can get the value with a single formula.

The post SUMIFS, COUNTIFS & AVERAGEIFS appeared first on Xelplus - Leila Gharani.