Results 1 to 3 of 3

Thread: Sum based on weeks

  1. #1

    Sum based on weeks



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I download a file from a time management system every week, where I have loads of data. What is relevant for this formula is the week number, and expense correlated to this week number. Expense is hours * price per hour.

    Week number is quoted as 01.2016, 02.2016, etc. to 52.2016 (it starts at 01.2014). And there are several rows for every week.

    I need a formula that sums up the expense for each year.

    I have tried several things, e.g.: =SUMIFS(Expense_column;week_column;"??"&".2016") to get the expense for 2016, but no luck.

    If anyone can help me, that would be great. If you need some more information, please do tell, but I think I have written down all the relevant info.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,286
    Articles
    0
    You can't use those wildcards on dates.

    Try:

    =SUMIFS(Expense_column;week_column;">="&Date(2016;1;1);week_column;"<="&Date(2016;12;31))


  3. #3
    It didn't work with the week_column, but I replaced that with the date_column, and it worked:
    =SUMIFS(Expense_column;date_column;">="&Date(2016;1;1);date_column;"<="&Date(2016;12;31))

    Thanks NBVC!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •