formula to code help

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

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
 
Why?

If it works, a worksheet function is usually better than VBA.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Range("A1").Formula =
"=SUM(Detail!R2C7:R60000C7,(IF(Detail!R2C11:R60000C11=1998,IF(Detail!R2C13:R
60000C13=""LB"",IF(Detail!R2C10:R60000C10=""Bodily
Injury"",IF(Detail!R2C7:R60000C7=""Open"",1,0))))))"

Watch the line wrap.
 
Back
Top