formula to code help
Range("A1").Formula =
"=SUM(Detail!R2C7:R60000C7,(IF(Detail!R2C11:R60000 C11=1998,IF(Detail!R2C13:R
60000C13=""LB"",IF(Detail!R2C10:R60000C10=""Bodily
Injury"",IF(Detail!R2C7:R60000C7=""Open"",1,0))))) )"
Watch the line wrap.
--
Vasant
"JohnE" wrote in message
...
I have the following formula that I was able to do. But I
prefer to put this into code and attach it to a button
that has several other events to it. But since I am
having a brain freeze, can not figure out how to put this
into code. Can someone get me started correctly? Is
there a website to go to for tips and tricks?
=SUM(Detail!$G$2:$G$60000,(IF(Detail!$K$2:$K$60000 =1998,IF
(Detail!$M$2:$M$60000="LB",IF(Detail!$J$2:$J$60000 ="Bodily
Injury",IF(Detail!$G$2:$G$60000="Open",1,0))))))
Thanks to anyone who responds.
*** John
|