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

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

I have a multiple-step simple formula that I need to implement, I have attached a sample below, essentially I want to add A1+B1 then divde it by C1, I then want that result to sum with all the other results below it (ex. A2+B2/C2 etc.). The part I dont know is how to do that for mutiple rows without throwing in an additional column. Basically I need to do whats in the gray boxes in 1 formula without needing those two gray columns to pull from, my explanation is confusing but the problem is simple I know it. PLease help! thanks everyone :-]Example Multi Step Math.xlsx  Register To Reply

2. Re: 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  Register To Reply

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

BEAUTIFUL! I knew it was simple.

So basically its summing and dividing, now heres my question, only if its not zero? is that what the <> do? everything else I understand, but the <>0 i don't  Register To Reply

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

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  Register To Reply