Re: $$Excel-Macros$$ Re: Sumif multiple column

as per ur sheet u can use below formula. =SUMIF(B3:B10,B15,G3:G10) On Fri, Sep 30, 2016 at 11:02 AM, N. Madhan wrote: > > Hi > > file attached sumif & sumifs function see that > > sumif function only single columns select > > > On Friday, August 26, 2016 at 10:52:18 AM UTC+5:30, Deepak Rawat

$$Excel-Macros$$ Re: Sumif multiple column

Hi file attached sumif & sumifs function see that sumif function only single columns select On Friday, August 26, 2016 at 10:52:18 AM UTC+5:30, Deepak Rawat wrote: > > Hi, > > Need sumif function to sum multiple columns > > sample excel attached. > > Regards, > Deepak > -- Are you =EXP(E:R

$$Excel-Macros$$ VBA - checking for success of a Global Replace

One of the first steps in my macro does a global replace, looking for "BLKY046**" and replace it with "LKAREA". I would like to use this Replace as a means to keep the macro from running again if it has already been run once. Basically, if the Replace can't find "BLKY046**" it means I already ran