Saved Bookmarks
| 1. |
Solve : Excel 2007 help 'COUNTIF'? |
|
Answer» I am trying to find the frequency of certain numbers. I have ranges 10<20 and 20<30 etc. I use this formula - for example - =COUNTIF(D3:D136,">=10")-COUNTIF(D3:D136,">20") but the problem that i am get is that it is still picking up everything from 10 to 20, when what i WANT it to do is tally the numbers from 10 to 'less than' 20, - 10<20 - yet the above equation is INCLUDING 20s' Any help?Try REPLACING > with >= in (D3:D136,">20"). Does that work? Quote from: SOYBEAN on MARCH 19, 2011, 05:50:11 PM Does that work? Like a charm, thanks Soybean |
|