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

2012-04-08 Thread Maries
Haseeb, *{1,-1}* Your Idea Solid. On Mon, Apr 9, 2012 at 6:41 AM, Haseeb A wrote: > =SUM(SUMIF(G3:G409,{">350",">449"},$D$3:$D$409)*{1,-1}) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need H

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

2012-04-08 Thread Haseeb A
Hello Lee, One way: =SUM(SUMIF(G3:G409,{">350",">449"},$D$3:$D$409)*{1,-1}) Will sum 351-449. if you want to include 450, change 449 to 450 ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea