Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
i've got a spreadsheet that has B10 through Y10 (all the way down through
B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I go about setting up the spreadsheet with this formula without having to do each box seperately (b10, c10, d10, b11, c11, d11 and etc)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Your formula is using relative references, if you copy and paste it should
change the ranges accordingly (the cell below will get B11, the cell on the right C11, etc). Is this what you were asking? Miguel. "sunrosejenn" wrote: i've got a spreadsheet that has B10 through Y10 (all the way down through B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I go about setting up the spreadsheet with this formula without having to do each box seperately (b10, c10, d10, b11, c11, d11 and etc)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
ok that work great if it were a small spreadsheet. but I've got 3
spreadsheets total of 2952 boxes. my hand will fall off if I copy and paste each one. someone had accidently deleted the original formula's for this spreadsheet and I was given the task to fix it as the person who did it is no longer with the company. isn't there a way to do the whol spreadsheet at once? thanks Jeannette "Miguel Zapico" wrote: Your formula is using relative references, if you copy and paste it should change the ranges accordingly (the cell below will get B11, the cell on the right C11, etc). Is this what you were asking? Miguel. "sunrosejenn" wrote: i've got a spreadsheet that has B10 through Y10 (all the way down through B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I go about setting up the spreadsheet with this formula without having to do each box seperately (b10, c10, d10, b11, c11, d11 and etc)? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Just drag it down or across - B10 is a relative reference, so will
automatically change to C10, B11 etc "sunrosejenn" wrote in message ... i've got a spreadsheet that has B10 through Y10 (all the way down through B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I go about setting up the spreadsheet with this formula without having to do each box seperately (b10, c10, d10, b11, c11, d11 and etc)? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Thank you. I don't know a thing about formula's except simple adding ones
Jeannette "Heather Heritage" wrote: Just drag it down or across - B10 is a relative reference, so will automatically change to C10, B11 etc "sunrosejenn" wrote in message ... i've got a spreadsheet that has B10 through Y10 (all the way down through B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I go about setting up the spreadsheet with this formula without having to do each box seperately (b10, c10, d10, b11, c11, d11 and etc)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |