incremenT CountIF Value

  • Thread starter Thread starter infojmac
  • Start date Start date
I

infojmac

i'm not sure i've expressed my problem clearly.

say in column A i have the values 1,2,3,4 and 5 so it may run like
this
5
1
1
2
1
3
3
4
1
4

Then i do a COUNTIF(A:A,"1") which gives me a total of 4.

So now i want to do the following with 2 and then 3 and then 4 and so
on.

Which wouldn't be so bad but my range of numbers goes on to over 100 so
it would be easier if somehow i could increment the value the countif
function is looking for, rather than typing in each countif on the
column A

Cheers,

John
 
That's what my solution would give.

Column B would be numbers 1 - 100 and column C would show how man
times each of those values appeared in the list

If you want the countif formula to remain as a single cell and show th
frequency of 1 and then 2 then 3 etc I think you are going to need t
use VBA
 
You may want to look at Data|Pivottable to get your counts.

Or you could put 1 to 100 in a column of cells (C1:c100???)

and adjust your formula to something like:

=countif(a:a,c1)

and drag down.
 
Back
Top