Need a formula for counting information based on date

Need a formula for counting information based on date


I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give me the sum based on the date. For example, on 1/17 I will have 6 rows with data that shows hours of worked for each team. This week on Friday we will have new data, so I want the formula to be able to tell me what's my sum for the whole week. If this makes sense, like below, on the Sum column I want the total hours for week ending 1/17 and 1/24 and so forth. I am open to using anything, if anyone has any other suggestions on representing this, please let me know.


Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Here is another rather flexible option...

    =SUMIFS([Total Hours]:[Total Hours], [Week Ending]:[Week Ending], [Week Ending]@row)

    This will sum all of the numbers in the [Total Hours] column that have the same date in the [Week Ending] column as the date in whatever row the formula is on.


Sign In or Register to comment.