Excel Formulas

In Excel, to conditionally calculate total, I will use the SUM function that sums up the numbers.

In Excel, to sum values based on the selection of drop-down list with the All option, I use data validation, the SUMIF and the IF function.

In Excel, to calculate sum and average and find maximum and minimum value, use data validation and use SUM, AVERAGE, MAX, MIN and INDIRECT functions.

In Excel, to convert "P" to checkmark and "O" to crossmark, apply the Wingdings 2 font. Count checkmarks and crossmarks using COUNTIF function.

In Excel, to sum range based on the selection of drop-down list, I use data validation, the SUM and the INDIRECT function.