im not sure what im doing wrong but i still cant get any results from that
I think I need to start gradually, what would help me to understand is how
might one type a formula for (column 1)*(column 2 only if column 3 has text
in it)?
Thank you for your understanding & help
"B.H.JIG" wrote:

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(IMPORT S!T2:T50000,"*"))