try this
Range("T2").FormulaR1C1 =
"=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"")" _
&
"+COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
On Friday, March 2, 2018 at 10:07:27 PM UTC+5:30, Johnny
Maybe not clear? after ")" in top line I think quote mark after ), so )"
then and & then the _
then the low line start with a quote before the +, so "+.
It has been a while, but I think this will work.
Thanks, David
On Friday, March 2, 2018 at 8:37:27 AM UTC-8, Johnny wrote:
>
> I'm having
I am not sure, but I think you need to end the top line with a quote mark
then the & and similar to that with the bottom line qand start with a quote
" mark", may have to experiment with the Quotes to get it right. Hope it
helps. Thanks, David
On Friday, March 2, 2018 at 8:37:27 AM UTC-8,