Hylton Conacher(ZR1HPC) wrote: > > TerryJ wrote: >> >> <snip> Having said that, I should belatedly ask about your example >>>> =Sum($Totals-<month name>.d2). Is the <month name> part of a sheet >>>> name >>>> and >>>> why use SUM for what seems to be a single cell? >>> Sorry, error in the above formula. Copying the formula from cell E5 from >>> the current sheet named(Apr) gives: >>> >>> =SUM(($Totals.B5-SUM(D3:D4))/(30-COUNT(D3:D4))) >>> >>> I still do not see how implementing the INDIRECT function is going to >>> allow me to link to the Master sheet formulae but use the data from the >>> sheet that the formula is pasted onto. >>> >>> >> >> Ok. I admit that I've got no idea now what you're trying to do. I take >> it >> the document has changed since you provided a copy previously. How about >> uploading a copy to http://www.mytempdir.com/ and providing a link. Not >> everyone on the list wants to receive a copy. > > Not a bad idea at all. Tnx Terry. Users can now get the file with a file > ID of 1282246. > >> When providing the link, please identify by name the sheet which is the >> "master sheet". > > The Master sheet is named as such and is the second sheet in the file. :) > > "Master" looks like a template to me. I gather from your messages that you are copying the formulas from the template and pasting them onto the monthly sheet. You could just right-click the tab of "Master", select Move/Copy Sheet, choose the position where you want the copy, select the box labelled "Copy" and press "Ok". Rename the new sheet "May". In E4 of the Master, you have =SUM(($Totals.B5-D3))/(30-COUNT(D3)) . Do you want to substitute the actual number of days in the month for 30? If so, use a cell for the number of days. I suggest A34 which is blank in "Master". In that cell, for April, enter 30. Your formula changes to =SUM(($Totals.B5-D3))/(A34-COUNT(D3)) for all sheets. I think you have been doing this the hard way. A good place to start but I understand your wish to move on. -- View this message in context: http://www.nabble.com/Varying-sheet-specific-master-formula--tf3475042.html#a9849428 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
