Thread: [Solved] Whats the correct formula to point to the last populated cell in a column?
View Single Post
 
Old 03-08-2021, 11:09 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
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)
Reply With Quote