Re: $$Excel-Macros$$ Help needed in sum

Thank you its working On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya wrote: > Hi Rambabu, > > Find the attached file. > > use this formula. > > =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15) > > Regards > Amresh > > > > > On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI > wrote: > >> Please try >>

Re: $$Excel-Macros$$ Help needed in sum

Hi Rambabu, Find the attached file. use this formula. =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15) Regards Amresh On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote: > Please try > > =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) > > > On Mon, Sep 3, 2012 at 5:17 PM, Rambabu

Re: $$Excel-Macros$$ Help needed in sum

Dear Ram, If you working in prior version of Excel 2007 You can use =SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24<=O15)*($I$15:$I$24)) On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote: > Please try > > =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) > > > On Mon, Sep 3, 2012 at 5:17

Re: $$Excel-Macros$$ Help needed in sum

Please try =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote: > Dear all, > > > -- > Regards > Rambabu. G > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members alre