Excel dropdown SUM, AVERAGE, MAX and MIN using INDIRECT
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.
Excel checkmark and crossmark counter using COUNTIF
In Excel, to convert "P" to checkmark and "O" to crossmark, apply the Wingdings 2 font. Count checkmarks and crossmarks using COUNTIF function.
Excel range dropdown SUM using INDIRECT
In Excel, to sum range based on the selection of drop-down list, I use data validation, the SUM and the INDIRECT function.
- Go to the previous page
- 1
- …
- 13
- 14
- 15
- 16