I am trying to email a spreadsheet to someone but the formulas are not
working on the email version for one of the worksheets. It is not linked to
any file outside of the worksheet. Any assistance

Hi Daniel,
I am trying to email a spreadsheet to someone but the formulas are
not
working on the email version for one of the worksheets. It is not
linked to any file outside of the worksheet. Any assistance

download the add-in for free.

http://www.rondebruin.nl/mail/add-in.htm

arno

This will get the last value entered in column A

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

This will get the ROW # of the last entry in Col A.

=MATCH(9.99999999999999E+307,A:A)

This will sum the last 60 entries in a column - assuming a header in row 1
and no blank cells

=SUM(OFFSET(A2,MAX(0,COUNTA(A2:A65536)-60),0,60,1))

"Daniel" wrote:

I am trying to email a spreadsheet to someone but the formulas are not
working on the email version for one of the worksheets. It is not linked to
any file outside of the worksheet. Any assistance

Wrong thread - sorry!!


"Duke Carey" wrote:

This will get the last value entered in column A

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

This will get the ROW # of the last entry in Col A.

=MATCH(9.99999999999999E+307,A:A)

This will sum the last 60 entries in a column - assuming a header in row 1
and no blank cells

=SUM(OFFSET(A2,MAX(0,COUNTA(A2:A65536)-60),0,60,1))

"Daniel" wrote:

I am trying to email a spreadsheet to someone but the formulas are not
working on the email version for one of the worksheets. It is not linked to
any file outside of the worksheet. Any assistance