Whats the correct formula to point to the last populated cell in a column?

ArviLaanemets · #3 03-08-2021, 11:09 PM

Code:

=SUMIFS($D$4:$D$37,$A$4:$A$37,TODAY())-SUMIFS($D$4:$D$37,$A$4:$A$37,TODAY()-1)

Or, when adding a column header for dates (e.g. renaming header Date to Day, and naming leftmost column with dates as Date), and getting rid of special characters in column names (e.g. renaming # REPORTED TODAY AS Reported), you define your table as Table (Insert>Table) and giving it a name e.g. YourTable:

Code:

=SUMIFS(YourTable[Reported],YourTable[Date],TODAY())-SUMIFS(YourTable[Reported],YourTable[Date],TODAY()-1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF cell in Col A is populated BUT cell in Col C is blank DELETE ROW	ChrisOK	Excel Programming	7	05-05-2019 09:00 PM
Filling a formula down a column where only one cell value referenced changes?	sakurasanta86	Excel	1	08-27-2018 03:23 AM
formula help - value in cell looking up row and column using great than less than	stefano	Excel	3	10-20-2017 02:20 PM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM