 # Get instant live expert help on sum if date “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need a sum if the location has a completion date
Solved by S. S. in 19 mins
I want the formula =SUM(I2+1095) to calculate only IF I2 has a date in it
Solved by G. C. in 12 mins
I need a formula to sum the amount if the date from another worksheet is the same as the date in the other worksheet for a given category
Solved by B. Y. in 21 mins
I need a formula(s) to find the SUM of Hours that are Past Due/Upcoming: - Outstanding - If Start Date is yesterday or older & - In Progress/Upcoming - If their Start Date is today/future.
Solved by B. E. in 29 mins
I am trying to get a cell to sum two different cells if criteria are met. Specifically, I want the "Commission this Pay Period" column to sum corresponding cells in the row for column only if the date, in another column, is less than the date specified in the formula. So, if columns S and U (Date Paid) is less than 6/5/2018, column O (Commission this pay period) will reflect the sum of corresponding cells in columns R and T. if the dates in columns S and U are greater than 6/5/2018, then 0. I need this to work if one date meets the criteria even if the other one doesn't.
Solved by T. L. in 26 mins