I would appreciate any help on the following formula which I cannot
get to work:
=IF(AND('TEST PLAN'!$U$14:$U$10134="11",(IF(SUM(IF('Test Plan'!$I$13:$I
$10134="NB",1,0)))>0,SUM(IF('Test Plan'!$I$13:$I$10134="NB",1,0)),
0)+IF(SUM(IF('Test Plan'!$I$13:$I$10134="QU",1,0))>0,SUM(IF('Test
Plan'!$I$13:$I$10134="QU",1,0)),0)+IF(SUM(IF('Test Plan'!$I$13:$I
$10134="SLIQ",1,0))>0,SUM(IF('Test Plan'!$I$13:$I$10134="SLIQ",1,0)),
0)+IF(SUM(IF('Test Plan'!$I$13:$I$10134="PQB",1,0))>0,SUM(IF('Test
Plan'!$I$13:$I$10134="PQB",1,0)),0))))-A3
I am trying to qualify the formulas at the beginning by testing to see
if 'TEST PLAN'!$U$14:$U$10134="11" if it is true then I want to
proceed with the rest of the formulas.
Thank you for any help.
Mike B
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
