Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to code help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to code help
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code the formula? | Excel Discussion (Misc queries) | |||
formula or code | Excel Worksheet Functions | |||
Formula or VBA code help | Excel Programming | |||
SUM Formula using code | Excel Programming | |||
Formula or code | Excel Programming |