Find the last used cell by starting from the top and going down.

[johndrew]

Fellows I need to find the last used row by starting in B1 and going down.

 

[AhoyNC]

See if one of the formulas below gives you what your looking for.

Formula in D1 will give you the last row number that's not blank
Formula in D2 will give value in last cell
Formula in D3 will give you the cell address

The formulas in D1 and D3 are array formulas and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E	F
1		34		12	Last Row #
2		89		rt	Last Value
3				$B$12	Cell address
4		fg
5		hj
6		3454
7		3
8		rt45
9
10		5667
11		455
12		rt
13
Sheet3

 

[johndrew]

What I need is to find the last used row
Add another Row
Draw a Line on top of this new row
Sum Columns B,C, D
Name the Last Cell in Column D as Grand Total
Put Grand Total In Cell D1 ( I could have up to 100 entries) so they can easily see the Total Cost