Milgard Manufacturing interview question

why do excel show if and sum?