Forum Discussion
Updating a daily total
Hello. I have a spreadsheet with columns showing daily costs for several items across the page with the date at the far left and daily totals at the far right. At the top of the page, I have a large ...
Its's as simple, and no need to convert data in a TABLE, you may use any of these formula:
=LOOKUP(2,1/(ISNUMBER(L:L)),L:L)
or
=LOOKUP(2,1/(L:L<>""),L:L)Or
=INDEX($L$7:$L$10,COUNTA($L$7:$L$10))
Adjust cell references in the formula as needed.