=Sum("Formula", "Tips")

Shortcuts,
    Alt + Equal(=)
    Alt, H, U, S

Basic,
   Total  =SUM(A1,A2,A3)
   Total  =SUM(A1:A3,B1:B3)
   Total  =SUM(A:A 1:3)


Advance,
    =SUM(AVERAGE(A1:A3),MAX(B1:B3))


Array,
   Countif =SUM(--(A1:A10="Apple"))
   Character Count =SUM(LEN(A1:A10))
   Sum Unique Values =SUM(IF(FREQUENCY(A1:A10,A1:A10)>0,A1:A10,0))
   Count Unique Values =SUM(IF(A1:A10<>"",1/COUNTIF(A1:A10,A1:A10),0))