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