Re: $$Excel-Macros$$ pls help with sum if formula

also you can use the below formula if you are using ms office 2007 or later versions =sumifs(d3:d409,g3:g409,">350", g3:g409,"<450") On Mon, Apr 9, 2012 at 10:11 AM, Maries wrote: > Hi, > > Try Below Formulas, > > =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409) > > =SUM(IF(--(G3:G409>35

Re: $$Excel-Macros$$ pls help with sum if formula

Hi, Try Below Formulas, =SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409) =SUM(IF(--(G3:G409>350)*(G3:G409<450),D3:D409,0)) Note: second one is Array formula. Apply with Ctr + Shift = Enter. Regards, MARIES. On Mon, Apr 9, 2012 at 5:09 AM, Sara Lee wrote: > =SUMIF(G3:G409,"<350",$D$3:$D$