1

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

SumIf

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

0

=SUMPRODUCT(QUERY({A9:B}, 
 "select Col2 
  where Col1>=date'"&TEXT(B1, "yyyy-mm-dd")&"' 
    and Col1<=date'"&TEXT(B2, "yyyy-mm-dd")&"'"))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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