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