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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!