Any Nested If Function Experts Here This Evening?

[hsnmef]

I am trying to get rid of some really pesky DIV/0 and #VALUE errors. The formula I would like to create would look at range1, decide if the total is zero, display zero and then look at range2, decide if that total was zero and then disply zero, additionally, if the totals were not zero then it would perform a further calculation of totaling range1 and then totaling range2 and dividing range1 by range2

I have tried many variations of this formula without success. =IF('Staff Detail'!S15:S25=0,0,IF(C10:C11=0,0))+SUM('Staff Detail'!S15:S25,/C10:C11)

Any blatant errors you can point out would be sincerely appreciated!

 

[hsnmef]

You all are just two excel gurus! I couldn't figure out how to make it work at all and you could come up with two ways get it done in no time at all!

So you are both better at this than I am, and I really am no excel slouch, but clearly no match for the likes of you two... So how long did it take you to master excel at this level and do you use it to do more than 50% of your job daily or just really enjoy the challenge?