Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help pulling info from other sheeting withing a workbook.
okay, i have 1 workbook with 4 sheets. Sheets names are say, sheet1, sheet2, sheet3 and sheet4. on sheet4, i want to create a formula that will pull rows B2 to H2 from sheet1, B2 to H2 on sheet2 and B2 to H2 from sheet3 (it will be a STDEV formula) i've come up with: Code: -------------------- =STDEV('sheet1'!B2:H2) -------------------- which will pull the info from sheet1, but i can't figure out how to add in the data from the other 2 sheets. is it possible? if so, how? any help would be greatly appreciated -- Plasma ------------------------------------------------------------------------ Plasma's Profile: http://www.excelforum.com/member.php...o&userid=27404 View this thread: http://www.excelforum.com/showthread...hreadid=469179 |
#2
|
|||
|
|||
Hi, Plasma. This should help you:
http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "Plasma" wrote in message ... okay, i have 1 workbook with 4 sheets. Sheets names are say, sheet1, sheet2, sheet3 and sheet4. on sheet4, i want to create a formula that will pull rows B2 to H2 from sheet1, B2 to H2 on sheet2 and B2 to H2 from sheet3 (it will be a STDEV formula) i've come up with: Code: -------------------- =STDEV('sheet1'!B2:H2) -------------------- which will pull the info from sheet1, but i can't figure out how to add in the data from the other 2 sheets. is it possible? if so, how? any help would be greatly appreciated -- Plasma ------------------------------------------------------------------------ Plasma's Profile: http://www.excelforum.com/member.php...o&userid=27404 View this thread: http://www.excelforum.com/showthread...hreadid=469179 |
#3
|
|||
|
|||
Try using =STDEV('sheet1'!B2:H2,'sheet2'!B2:H2,'sheet3'!B2:H 2,'sheet4'!B2:H2) -- tobriant ------------------------------------------------------------------------ tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155 View this thread: http://www.excelforum.com/showthread...hreadid=469179 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Track info from one w/sheet onto another. | Excel Worksheet Functions | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel | |||
paste info into merged cells | Setting up and Configuration of Excel | |||
trying to sort/farmat scanned info | Excel Discussion (Misc queries) |