Hey people,
I'm currently trying to break up my data into ranges e.g. 101 to 200
And heres my formula
The problem im having is its saying there's 0 so im not to sure.Please Login or Register to view this content.
Greatful for any help, thanks
Hey people,
I'm currently trying to break up my data into ranges e.g. 101 to 200
And heres my formula
The problem im having is its saying there's 0 so im not to sure.Please Login or Register to view this content.
Greatful for any help, thanks
Last edited by dannyshezo; 12-14-2011 at 05:09 PM.
Assume you need to count between >=101 AND <=200
If you are on XL 2007 or late use COUNTIFS like,
=COUNTIFS(milestone1a!E7:E126,">=101",milestone1a!E7:E126,"<=200")
Or,
The following formulas will work with any versions.
Use COUNTIF like,
=COUNTIF(milestone1a!E7:E126,">=101")-COUNTIF(milestone1a!E7:E126,">200")
=SUM(COUNTIF(milestone1a!E7:E126,">"&{100,200})*{1,-1})
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thanks, seems to be working now, only issue i have is that i ammended the formula to suit another range and now its displaying 0 for that range,
Thanks for your help
Can you please the formula you tried? How's the range formatted? If the range formatted or numbers entered as text this wouldn't work.
Try this. Select the range go to Data >> Text to columns then click Finish. What is the answer you getting now?
The range i am doing is 201 - 300 so i literally just changed the 101 and 200 from the last formula as the countif range is the same so im using;
I did like you said but nothing changed, but the when i did 101 to 200 it works yet by changing the figures, it doesn't like it.Please Login or Register to view this content.
Last edited by dannyshezo; 12-14-2011 at 05:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks