Need a Quotient of a multi division and addition series)

Let us say we use H9:H15 and E9:E15

I would like to Add H9:H15, Add 7, and divide this by 100
........SUM(H9:H15,7)/100

I would like to Add E9:E15
........SUM(E9:F15)

Simple so far, as we have =SUM(H9:I15,7)/100 +SUM(E9:F15)

I would then like to add both sums together, divide by 10 and get the quotient.

Since the formula is QUOTIENT(numerator,denominator), how can I put this entire series into one formula.

here is the code:

Please Login or Register  to view this content.

Originally Posted by noexcel=badwork

here is the code:

Please Login or Register  to view this content.

I tried that before. It doesnt work.

It is interpretting =SUM(H9:H15)/100 and SUM(E9:E15)/10 separately, then adding them.

It is diving by the last 10 before it adds the SUM(E9.., I need it to add it all together first THEN divide by 10.

I might simply have to some cells set aside to do the calculations separately. Thanks.

an approach similar to Ote without INT
will give the right calculation
this is the code:

Please Login or Register  to view this content.

hopefully that will help you

Originally Posted by DonkeyOte

Do you mean:

Please Login or Register  to view this content.

(you could use QUOTIENT but INT would suffice here given denominator of 1)

YES! This works Thanks, DonkeyOte.

I knew how to make nested IFs, but not nested SUMs. With being so used to (((2+2)x4)+7), I tried coding the same way. SUM(SUM( is the key I was not aware of.

Again many thanks!