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 ...
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: