Results 1 to 2 of 2

Thread: Help with SUMIFS

  1. #1

    Help with SUMIFS



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

    Hi

    I have a spreadsheet which is using SUMIF. I need to extend the range so that the data is also searched within a date range. SUMIFS seems to be the obvious way but I haven't been able to get the date range to work.

    Can anyone help me with this please?

    Stephen
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    On Sheet1 in the helper 'E' column set the formula
    Code:
    =TEXT(DATE(YEAR(B1);MONTH(B1);DAY(B1));"mmm")
    On Sheet2 set the formula
    Code:
    =SUMIFS(Data!$D$1:$D$1400;Data!$A$1:$A$1400;$C7;Data!$E$1:$E$1400;D$4)
    or
    Code:
    =SUMPRODUCT(($C7=Data!$A$1:$A$1400)*(D$4=Data!$E$1:$E$1400)*(Data!$D$1:$D$1400))
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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