Yes I tried using the sum formula with the Vlookup but it didn't work for me. My current formula as it stands is:

=VLOOKUP("Andre Stevens",March!A8:H52,8)

How would I add in the SUM formulae to this?