The 2 Most Important Excel Functions AND
AND

Lesson 13: SUBTOTAL Function in ExcelThe Excel function SUBTOTAL is a function that can execute 11 types of calculations. SUBTOTAL is a very useful formula for analysis of data directly from the data sheet. It will sum, count, calculate average....of the records that have been filtered in a database.
The syntax is very easy: In plain English: Execute calculation number 9 (sum) on all filtered records of range A2 to A50. If no filter is applied the calculation is executed using all the cells in the range. Calculation types: Types 7, 8, 10 and 11 are for users interested in statistics. As for type 6...

SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIF ¦ COUNTIFS ¦ SUMIF ¦ SUMIFS ¦ IFERROR