title: SumIf by Weekday & User
body: <p>I have a table that I am trying to perform a sumif on, but the catch is I need the formula to filter the data by two range criteria first. 
  Column A = Date, Column D = User, Column H = time to be summed</p>
  
  <p>Basically, I want to be able to sum the time values by user, but then I also need to be able to split this time between weekdays and weekends.</p>
  
  <p>Thus, if user A has 1 session of 0:30 on Monday, Wednesday, Saturday and Sunday, then I want the formula to be capable of summing the 2 hrs such that I can have 1 column in a separate table with the weekday hours, and the column next to this with the summ of all weekend hours.</p>
  
  <p>Any ideas you might have on how I can solve this with a formula rather than redesigning the tables (as they're not mine to redesign) would be most appreciated.</p>