Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-12 Thread Ashish Bhalara
Vijayendra, Kindly use the below formula, its quite easily done. =COUNTIFS(B2:D5,">=4000",B2:D5,"<=6000") Regards, Ashish Bhalara On Thu, Jan 12, 2012 at 12:47 PM, Vijayendra Rao wrote: > Dear All, > > I want to put countif range between 4000 to 6000. Please find attached > file for your refe

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-12 Thread Kris
Another one =SUM(COUNTIF(B2:D5,{">=4000",">6000"})*{1,-1}) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick att

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-12 Thread Vijayendra Rao
Dear Noorain & Priyanka, Thank you very much for your quick support. Formula is very useful. Thanks Vijayendra 2012/1/12 NOORAIN ANSARI > In Case of Excel 2003 > > you can use... > > *=SUMPRODUCT(--($B$2:$D$5>4000)*($B$2:$D$5<=6000))* > > > Thanks & regards, > Noorain Ansari > *http://excelma

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-11 Thread PrIyAnKa
Kindly try this formula =COUNTIF(B2:D5,">=4000")-COUNTIF(B2:D5,">6000") Regards Priyanka On Thu, Jan 12, 2012 at 12:47 PM, Vijayendra Rao wrote: > Dear All, > > I want to put countif range between 4000 to 6000. Please find attached > file for your reference. > > > Region Jan Feb Mar North 5

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-11 Thread NOORAIN ANSARI
In Case of Excel 2003 you can use... *=SUMPRODUCT(--($B$2:$D$5>4000)*($B$2:$D$5<=6000))* Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Jan 12, 2012

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-11 Thread NOORAIN ANSARI
Dear Vijayendra, Please use below formula and see attached sheet. *=COUNTIFS($B$2:$D$5,">"&4000,$B$2:$D$5,"<="&6000)* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

2012-01-11 Thread Vijayendra Rao
Dear All, I want to put countif range between 4000 to 6000. Please find attached file for your reference. Region Jan Feb Mar North 5000 6000 4500 South 5800 7000 3000 East 3500 2000 1 West 12000 4000 6000 Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for