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.
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!
You should read it
- Conditional counting function in Excel
- How to use DSUM function in Excel
- How to use COUNTIF function on Excel
- Instructions on how to use the Dmax function in Excel
- The SUMIFS function, how to use multiple conditional calculation functions in Excel
- How to calculate the total value based on multiple conditions in Excel
- How to use AVERAGEIF function in Excel
- How to use Conditional Formatting to conditional formatting in Excel
- How to list conditional lists in Excel
- Choose function in Excel, how to use the Choose function and illustrative examples
- Ms Excel - Lesson 13: Use conditional formatting in Excel
- How to use conditional formatting in Microsoft Excel 2016
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python