Updating a daily total

%3CLINGO-SUB%20id%3D%22lingo-sub-2125410%22%20slang%3D%22en-US%22%3EUpdating%20a%20daily%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2125410%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20have%20a%20spreadsheet%20with%20columns%20showing%20daily%20costs%20for%20several%20items%20across%20the%20page%20with%20the%20date%20at%20the%20far%20left%20and%20daily%20totals%20at%20the%20far%20right.%20At%20the%20top%20of%20the%20page%2C%20I%20have%20a%20large%20cell%20that%20displays%20the%20current%20daily%20total.%20At%20the%20moment%20I%20have%20to%20manually%20change%20it%20each%20day%2C%20by%20just%20copying%20the%20daily%20total.%20There%20must%20be%20a%20way%20to%20change%20it%20automatically%20using%20the%20date%2C%20but%20I%20can't%20work%20it%20out.%26nbsp%3B%20Sorry%20it%20the%20description%20is%20not%20clear.%20Any%20assistance%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2125410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2125605%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20daily%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2125605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F964359%22%20target%3D%22_blank%22%3E%40WarrenLord_Edgar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20need%20to%20convert%20your%20range%20into%20a%20table%20by%20selecting%20any%20cell%20with%20the%20range%20and%20pressing%20%3CSTRONG%3ECtrl%2BT%3C%2FSTRONG%3E.%20The%20table%20shall%20be%20named%20Table1%20but%20you%20can%20always%20replace%20it%20with%20a%20descriptive%20name%20you%20prefer.%20Thereafter%2C%20construct%20your%20formula%20as%20shown%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Twifoo_0-1613099701268.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254399iB5591767283B3173%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Twifoo_0-1613099701268.png%22%20alt%3D%22Twifoo_0-1613099701268.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 cell that displays the current daily total. At the moment I have to manually change it each day, by just copying the daily total. There must be a way to change it automatically using the date, but I can't work it out.  Sorry it the description is not clear. Any assistance would be greatly appreciated.

2 Replies

@WarrenLord_Edgar 

You may need to convert your range into a table by selecting any cell within the range and pressing Ctrl+T. The table shall be named Table1 but you can always replace it with a descriptive name you prefer. Thereafter, construct your formula as shown below:

Twifoo_0-1613099701268.png

 

@WarrenLord_Edgar 

 

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.