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)

"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