Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Arrow

    Hello! I have received help on this formula 2 weeks ago...but now the powers-to-be want more!!!!

    I have many worksheets.
    Work sheet 1 is the summary worksheet
    Work sheet 2 thru work sheet X are the data worksheet

    The title of work sheet 2 thru x are the combinations of cells B&" "&C from work sheet (ws from this point forward) 1.

    Row 3 of WS 1 is stating, sum the hour values from WS2!f:f that matches the weekending date from WS1!A2, and match the category selection from WS1!D2.

    Now the powers-to-be want the formula to say all above...and add....and only sum the hour values of those rows in WS2 where WS2!G:G is either "Cost" or "Both (CV/SV)"....ignore the hour values associated with "Schedule".

    Can anyone help me incorporate that criteria into my already existing formula? Attached is a ppt. slide that has the actual formula that is currently in WS1!D3.

    Thank you VERY MUCH for any and all help!!!!!!!!!
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does this do what you want?

    =SUMPRODUCT((INDIRECT("'"&$B3&" "&$C3&"'!$A2:$A65536")=$A$2)*(INDIRECT("'"&$B3 &" "&$C3&"'!$F2:$F65536")=D$2)*((INDIRECT("'"&$B3 &" "&$C3&"'!$G2:$G65536")="Cost")+(INDIRECT("'"&$ B3&" "&$C3&"'!$G2:$G65536")="Both (CV/SV)"))*INDIRECT("'"&$B3&" "&$C3&"'!$E2:$E65536"))

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786528' date='28-Jul-2009 13:55']Does this do what you want?

    =SUMPRODUCT((INDIRECT("'"&$B3&" "&$C3&"'!$A2:$A65536")=$A$2)*(INDIRECT("'"&$B3 &" "&$C3&"'!$F2:$F65536")=D$2)*((INDIRECT("'"&$B3 &" "&$C3&"'!$G2:$G65536")="Cost")+(INDIRECT("'"&$ B3&" "&$C3&"'!$G2:$G65536")="Both (CV/SV)"))*INDIRECT("'"&$B3&" "&$C3&"'!$E2:$E65536"))[/quote]


    Thank you so much HansV!!! You have helped so much!!!1

Posting Permissions

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