Help pulling info from other sheeting withing a workbook.

[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 a STDEV formula)



i've come up with:

Please Login or Register  to view this content.

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

[tobriant]

Try using

=STDEV('sheet1'!B2:H2,'sheet2'!B2:H2,'sheet3'!B2:H2,'sheet4'!B2:H2)

[Anne Troy]

Hi, Plasma. This should help you:
http://www.officearticles.com/excel/...worksheets.htm
************
Anne Troy
www.OfficeArticles.com


"Plasma" <Plasma.1vnxmo_1127228753.9817@excelforum-nospam.com> wrote in
message news:Plasma.1vnxmo_1127228753.9817@excelforum-nospam.com...
>
> 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
>