Multi-sheet Formula

[bjyes1]

I know this is rather simple, but I am going to post the question anyway:

I am trying to enter a formula in Excel, the data for which is in the same cell in every worksheet in the same workbook. It's akin to a three-dimensional formula where, for instance, a =sum formula calculates on data that's in each worksheet in the same cell.

Hopefully, I articulated the issue clear enough.

Can anyone provide the answer?

 

[JackDanIce]

Nope, not particularly clear.

What formula are you trying to do, SUM, AVERAGE, LEFT?

Making a guess, you can work with something like:

=SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1,Sheet4!A1)

It's easier to answer your question if you give better clarity, otherwise psychic powers are not enough to guess what your workbook looks like..

 

[T. Valko]

I know this is rather simple, but I am going to post the question anyway:

I am trying to enter a formula in Excel, the data for which is in the same cell in every worksheet in the same workbook. It's akin to a three-dimensional formula where, for instance, a =sum formula calculates on data that's in each worksheet in the same cell.

Hopefully, I articulated the issue clear enough.

Can anyone provide the answer?

There are very few functions that work across multiple sheets. The SUM function is one of them.

Something like this...

=SUM(Sheet1:Sheet10!A1)

 

[T. Valko]

psychic powers are not enough to guess what your workbook looks like..

That doesn't stop people from making WAG's, does it?

Seems every time I ask for more details 5 other people have posted suggestions based on their guess.

So, if'n ya want to be "relevant" around here ya gotta go with the flow!

Guess!

 

[bjyes1]

Many Thanks.

I think what you show in your reply is what I'm looking for.

 

[JackDanIce]

That doesn't stop people from making WAG's, does it?

Seems every time I ask for more details 5 other people have posted suggestions based on their guess.

So, if'n ya want to be "relevant" around here ya gotta go with the flow!

Guess!

It's even better when you have a informative header like "I need Excel Help!" you can play a great game of before clicking the link I wonder what they will ask..

What I find amazing is:
a) questions asked as if EVERYONE knows exactly what their spreadsheet looks like so obviously asking to "move a to b" is easy to answer

and

b) people who write like they're in conversation, you know what I mean? It's obvious right? For experts like you out there, should be easy

Annoys me mega, I'll get off my high-horse now, someone else's posting!

 

[T. Valko]

Many Thanks.

I think what you show in your reply is what I'm looking for.

Good deal. Thanks for the feedback!