Excel - Some useful functions

=LEFT(A2, LEN(A2)-2): Removes last two characters from contents of A2

=SUMPRODUCT(ARRAY1, ARRAY2...): Sum of the arrays' values

=IFERROR(VLOOKUP(A1, B2:E3, 4,0), 0): Change #NA to 0 while applying vlookup