Formula

T

Theresa

I'm working with a detail spreadsheet that was sent to me by someone else.
Can anyone decipher the following formula for me. I don't understand the
references "first" "last" in the formula.:

=SUM(First:Last!K560).


T.
 
R

Ron Rosenfeld

I'm working with a detail spreadsheet that was sent to me by someone else.
Can anyone decipher the following formula for me. I don't understand the
references "first" "last" in the formula.:

=SUM(First:Last!K560).


T.
Click to expand...

First and Last should be worksheet names (on the tabs).

This is a 3D reference and will sum the contents of K560 on all the worksheets
between First and Last (inclusive).


--ron
 
C

Charlie O'Neill

The First and the Last are referencing to worksheet names in a workbook.
What the formula is asking, sum the content of cell K560 in a worksheet name
First with the content of cell K560 in a worksheet named Last. So if K560 in
both sheet has the figure of 5 entered then the results would be 10.

Charlie
 
R

Ragdyer

To add to the other explanations:

Those 2 sheets named "First" and "Last" could also be *hidden*,
so you might not comprehend the formula's references.
 
D

Dave Peterson

One more...

First and Last are worksheets.

They usually have something in between them (and nothing important on them).

Then you can look at that as kind of a sandwich. With First and last being the
bread.

Your formula adds everything in K560 in between those two pieces of bread--just
the meat of the sandwich. (It actually includes the both pieces of bread,
too--so you'll usually find that First and Last are completely blank.)
 
Top