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.
- Calculate the total amount sold
In the cell to calculate enter the formula: = SUM (CHOOSE (2, D8: D14, F8: F14)) .
Press Enter -> total amount sold is:
- 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.
Pressing Enter will get the result:
Thus, using the Choose function helps you calculate conditional sum simply in the fastest way.
Good luck!