=1-SUMPRODUCT((IMPORTS!R2:R50000="Alpha")*(IMPORTS!V2 :V50000="Y"))/
SUMPRODUCT((IMPORTS!R2:R50000="Alpha")+((IMPORTS!T 2:T50000<"")*(NOT(ISNUMBE
R(IMPORTS!T2:T50000)))))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"B.H.JIG" wrote in message
...
The Question mark in the below formula represents the area that i am stuck
with. what i would like is to work out the % but only if T2-T50000
contains
some text, the computer suggests that i put brakets round the
COUNTIF(IMPORTS!T2:T50000,"*")) and a * before these brackets but that
will
not give a true % as the number that i am / by will be too high.
Thank you for any help or advice offered and I would like to Thank Max &
Pinmaster for helping me get this far!!!!




=1-SUMPRODUCT((IMPORTS!R2:R50000="Alpha")*(IMPORTS!V2 :V50000="Y"))/(COUNTIF(
IMPORTS!R2:R50000,"Alpha")?COUNTIF(IMPORTS!T2:T500 00,"*"))