Forum Discussion

JonD1993's avatar
JonD1993
Copper Contributor
Nov 15, 2023

Auto Sum cells up to todays date

Hi,

 

I want to Sum the Gangers Allowance in row 8. 

 

I used the formula =SUMIFS(E8:AM8, E6:AM6, "<="&TODAY()) to auto-sum only the hours from week 1 up to the current date.  this worked fine when I input the day's date in each column on row 6. Now that I have merged the weeks, the Sum only counts the Hrs in the Monday columns. 

 

how do I make it count all days?

 

 

excel
Formulas and Functions

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 15, 2023

    JonD1993 

    Enter the actual dates in row 7, formatted with the custom format ddd, so that they display Mon, Tue, Wed, etc., just as now.

    You can then use

    =SUMIFS(E8:AM8, E7:AM7, "<="&TODAY())

Resources