Find last number in a column...

[Mykro]

I have workbook with 3 different sheets that are I'm using as check registers. I want to create a sheet that will tally the running balances across of each of those sheets. So the question is: How do I reference the last number in a column?

Thanks

 

[Mykro]

The (A2:A1000>0) produces an array (list) of True or Falses. 1/True = 1 but 1/False = Error (ie a DIV0! as FALSE is equivalent to 0). So you end up with a list of 1s and error values. The 2 gets looked up against this list and returns the last valid number 9which is a 1 - the errors are ignored). The value in the corresponding lookup range (also A2:A1000) is then returned.

Make sense?

Yep.. Thanks