I am attempting to write a formula that will calculate the variance between
the sum of a cell and the number 40, but only if the sum of that cell is
greater than the number 40? I have tried several functions; i.e.: IF, SUMIF,
Etc., but I am unable to crack it. Can you help?

Much appreciated,

M