Want To Know Excel Array Formula Examples Being A Beginner

Asked By Hunter Kays 0 points N/A Posted on - 11/02/2017

I am learning Microsoft office, and I want to know different formulas in excel such as array formula. Quote some excel array formula examples so that I can understand the usage of an array formula.

• Status: Open
• Question Views: 393
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: Excel

Answered By Lawrence D Boyle 0 points N/A #305690

Want To Know Excel Array Formula Examples Being A Beginner

There are various excel array formula examples which can be used to determine various kinds of quantities in different worksheets. While you are a beginner, the best example for you to learn the use of array formula is what I am going to quote down –

USING THE ARRAY COMMAND TO KNOW THE COUNTS AND SIZES OF CELLS

In this kind of example, we are going to use an array formula to learn how to calculate the size of cells if we are two rows of different sizes. Here, we are going to compare the sizes if both the rows and calculate the amount by which one row is greater from the other.
Suppose we have to rows as A and B. If A is greater than B than by how much quantity A is greater.

By applying a simple formula, we can calculate this problem by =SUM((B2:B10>=A2:A10) * (B2:B10>0))

About Lawrence D Boyle

Questions
4

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/02/2017
• Question Category: Software Others