SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

You can use "array formulas" for this, i.e.

=SUM(IF(A2:A7<>0,(B2:B7+C2:C7)/A2:A7))

and

=SUM(IF(A2:A7<>0,E2:E7/A2:A7))

These formulas need to be entered with a specific key combination known as "CTRL+SHIFT+ENTER" - click on cell with formula - press F2 key to select formula then hold down CTRl and SHIFT keys while pressing ENTER. If done correctly you should get the correct results and curly braces like { and } should appear around the formula

Yes, that's right, only if it's not zero, because if you divide by zero you'll get #DIV/0! errors and SUM function won't ignore those so if you use just

=SUM((B2:B7+C2:C7)/A2:A7)

that will return #DIV/0! error in your example because the blanks in A2:A7 are treated as zeroes - that version will work if all A2:A7 values are all non-blank and non-zero