Originally Posted by
monkdelafunk
Hi guys!
I hope someone can help me because this is driving me nuts!
I'm making a spreadsheet with a column in which calculates an average of values across all worksheets by summing 2 figures and then dividing one by the other (in this case leads/hours to calculate average leads per hour). I've done this by creating a Start sheet and a Spacer sheet and then hiding them as the first and last sheets, and then summing with them as the start and end values. I have also figured in the dreaded dividing by zero error, so my formula looks like this:
=IF(ISERROR(SUM(Start:Spacer!Z4)/SUM(Start:Spacer!AA4)), "",SUM(Start:Spacer!Z4)/SUM(Start:Spacer!AA4))
This works fine. My problem is that I cannot create a template or save as a worksheet with these values because of the reference to the Start and Spacer sheets. My additional problem is that I need to email this spreadsheet to other offices and have it work out of the box, so creating a reference to the spreadsheet in the template is problematic down the line.
HELP!!!
Bookmarks