the process to only those rows which have an '11' in
Column U?
And can I assume that the '14' in IF(AND('TEST PLAN'!$U$14:$U$10134="11" should
really be a '13'?
Dave.
> Date: Wed, 12 May 2010 14:49:29 -0700
> Subject: Re: $$Excel-Macr
(IF(XYZ
> > ="SLIQ",1,0)),0)+IF(SUM(IF(XYZ ="PQB",1,0))>0,SUM(IF(XYZ
> > ="PQB",1,0)),0-A3
> >
> > But the whole thing looks very cumbersome, and discourages me from
> > diagnosing the error. Tell me, using words, what you want t
t;SLIQ",1,0))>0,SUM(IF(XYZ
> ="SLIQ",1,0)),0)+IF(SUM(IF(XYZ ="PQB",1,0))>0,SUM(IF(XYZ ="PQB",1,0)),0-A3
>
> But the whole thing looks very cumbersome, and discourages me from diagnosing
> the error. Tell me, using words, what you want to achi
ourages me from diagnosing
the error. Tell me, using words, what you want to achieve. Perhaps there is a
better way.
Regards - Dave.
> Date: Wed, 12 May 2010 13:00:44 +0530
> Subject: Re: $$Excel-Macros$$ IF AND formulas
> From: sandymau...@gmail.com
> To: excel-macros@goog
Hi Mike,
It will be better if you send a sample file with some data and your
query. As it may give you a shorter and simple formula for your task.
And about this formula, one can only show you the syntax error and
that not guaranteed for formula to give desired result.
So if you can than attach
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:
