CHOOSE function combines SUM - Conditional sum in Excel

The following article details how to use the CHOOSE function in combination with SUM- conditional sum in excel.

The following article details how to use the CHOOSE function in combination with SUM- conditional sum in excel.

1. The Choose function

Description: The Choose function is a simple and often used lookup function in excel.

Syntax: CHOOSE (index_num, value1, [value2] .) .

Inside:

- index_num : Location of returned data, for example if index_num = 1 => return value is value 1, index_num = 2 => return value is value2. The index_num value must be an integer or the result of a formula but must be an integer value. The index_num limit is between 1 and 29.

- value1 : Return value 1.

- value2 : The second return value.

Value values ​​range from 1 to 29.

Note: If index_num valueis not an integer, the #Value! Error value is returned.

2. Ham Sum

Description: The Sum function is the sum function in excel.

Syntax : SUM (number 1, number 2, .) .

In which : number 1, number 2 . are the values ​​to be calculated.

3. Example of using the Choose function in combination with the Sum function

For example, there is the following data table, calculating the total sold and the total number of items sold using the Choose function combined with Sum.

CHOOSE function combines SUM - Conditional sum in Excel Picture 1CHOOSE function combines SUM - Conditional sum in Excel Picture 1

- Calculate the total amount sold

In the cell to calculate enter the formula: = SUM (CHOOSE (2, D8: D14, F8: F14)) .

CHOOSE function combines SUM - Conditional sum in Excel Picture 2CHOOSE function combines SUM - Conditional sum in Excel Picture 2

Press Enter -> total amount sold is:

CHOOSE function combines SUM - Conditional sum in Excel Picture 3CHOOSE function combines SUM - Conditional sum in Excel Picture 3

- Calculate the number of items sold

Copy the formula to calculate the total amount to fix the index_num value in Choose by 1: = SUM (CHOOSE (1, D8: D14, F8: F14)) . Because the quantity column value is at the 1st position among the value values ​​of the Choose function, Index_num = 1.

CHOOSE function combines SUM - Conditional sum in Excel Picture 4CHOOSE function combines SUM - Conditional sum in Excel Picture 4

Pressing Enter will get the result:

CHOOSE function combines SUM - Conditional sum in Excel Picture 5CHOOSE function combines SUM - Conditional sum in Excel Picture 5

Thus, using the Choose function helps you calculate conditional sum simply in the fastest way.

Good luck!

5 ★ | 1 Vote