display last filled field of a column as total

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

I was wondering if I could get some help. I have a column of 'months
and a column of '$ amount'. The last row of month is 'total', which i
supposed to display the last months entry. How do I do that? Ex.
have filled until March (all the rest is 0), how do I get March to b
displayed at the end?

Many Thanks,

Marco
 
Hi Marcos,
A rather novel approach posted by Don Guillet, 2004-03-08, will
find the last number on sheet2 in col F. The trick is to look for
a large number that can't exist. Just make sure that your number
is not larger than your criteria. The last number is selected even
if non numbers appear below.
=INDEX(Sheet2!F:F,MATCH(9999999999,Sheet2!F:F),1)

Of course you have to not have zeros in the cells
as values below what you want. Don't know if
something like this would work for you or not.
=IF(SUM(D7:D8)=0,"",SUM(D7:D8))

Of course if zero is reportable value for some month you
will have to do something else.
 
Back
Top