Results 1 to 2 of 2

Thread: Formula

  1. #1

    Formula



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

    Hi ,
    can some one please help me?

    For H18 in sheet1 tab i want the following formula to be displayed
    =SUM((Tasks!I2:G7=1) * (Tasks!F2:F7))

    AND for H19 in sheet1 tab i want the following formula to be displayed
    =SUM((Tasks!I2:I7=1) * (Tasks!G2:G7))

    Please note that column I has conditional formating see attachment

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =SUMIF(Tasks!I2:I7,1,Tasks!F2:F7)

    and

    =SUMIF(Tasks!I2:I7,1,Tasks!G2:G7)

    your formulas are array formulas that would need to be confirmed with CTRL+SHIFT+ENTER to work.

    I also assume the range in the first formula should be I2:I7...


Posting Permissions

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