Tom’s Tutorials For Excel: Summing to Today’s Date With INDIRECT

Tom’s Tutorials For Excel: Summing to Today’s Date With INDIRECT

Here’s an example of using the INDIRECT and SUM functions to add numbers from the top of column B to the row where today’s date (or whatever date you specify) is found in column A.

The formula in cell E2 is
=SUM(INDIRECT("B1:B"&MATCH(E1,A:A,0)))

If you want to bypass the helper cell for today’s date, the formula would be
=SUM(INDIRECT("B1:B"&MATCH(TODAY(),A:A,0))).