Excel Formulas and Functions

• Sample Formula: “=SUM(C2:C4)”
• “=AVERAGE(C2, C3, C4)”
• Sample Formula: “=COUNT(C1:C4)”
• “=SUBTOTAL(1, A2: A4)”
• “=SUBTOTAL(4, A2: A4)”
• “=MOD(A2,3)”
• “= POWER (A2,3)”
• “=CONCATENATE(A25, ” “, B25)”