Help pulling info from other sheeting withing a workbook.

P

Plasma

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
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 ad
in the data from the other 2 sheets. is it possible? if so, how?

any help would be greatly appreciate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect used in an array formula 3
use dates to create a summary report 1
Simple way to get cell location as text "A2" 4
summing same cell in multiple worksheets 3
Excel Formula 5
Join same cells from different sheets as text 2
Automating copying of data from different worksheets. 2
Excel help with Macro code in excel 1

Top