I'm attempting to calculate a total number of hours based on entering 2 different dates. Each day between the dates has assigned 'hours worked'.

I'm trying to use Sumproduct or Arrayformula and Sumif, not having luck with either as of just yet... Any help appreciated :)

sum from lookup table


As far as i've got is selecting 2 dates and adding them together. Not everything inbetween

1 Answer 1


 "select Col2 
  where Col1>=date'"&TEXT(B1, "yyyy-mm-dd")&"' 
    and Col1<=date'"&TEXT(B2, "yyyy-mm-dd")&"'"))



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.