Well the wholw problem is explained in the comment section of the attached sheet...
Well the wholw problem is explained in the comment section of the attached sheet...
=COUNTIFS($B$2:$B$25,">0",$B$2:$B$25,"<0.05")
Add the dolar sigh to make your ranges absolute.
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
hi , its working fine.....actually I forgot to add one more thing in the sheet.... i have attached the sheet again .....could u please have a look on the problem mentioned there....
like this
=COUNTIFS($B$2:$B$25,">"&C2,$B$2:$B$25,"<"&C3)
thanks alot its working fine...............
You are welcome.
Please add reputation if you happy with the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks