0

I have this working formula (below)

=SUM(QUERY(QUERY({{A2:B},{ARRAYFORMULA(IF(LEN(A2:A), WEEKNUM(A2:A, 16), ))}}, 
 "select *", 0), 
 "select Col2 
  where Col3 matches '"&WEEKNUM(TODAY(), 16)&"'", 0))

What do i need to change to get my Total from the current month?

-1

SOLVED, used another type of formula

  • Hi woodie, please elaborate a little on what your actual solution was, otherwise the answer won't really be useful to anyone with the same problem. Thanks! – jonsca May 26 at 2:50

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.