Explanation

This formula uses the named rangekey(C4:G4) for convenience only.

Without the named range, you’ll want to use an absolute reference so the formula can be copied.

These values can be numbers, cell references, ranges, arrays, and constants, in any combination.

Excel formula: VLOOKUP calculate grades

SUM can handle up to 255 individual arguments.

COUNTA does not count empty cells.

Excel formula: Must pass 4 out of 6 subjects

Excel SUM function

Excel COUNTA function