# Thread: Need to enhance formula...

1. 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!!!!!!!!!

2. 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. [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
•