Excel: Theory

=lookup is look up function. Simple formula is (This , Here)

All formulas have brackets, and commas.

Do Not highlight titles when you highlight lists.

Type name to replace number you must press enter otherwise it won't confirm. e.g B3 to Marks, ENTER.

=countif is a counting function. Simple formula is (In this list , Count how many..)