# Countifs

I want to plot the distribution of column A having 14 numbers by counting into buckets in column B
ColA          ColB
421,006        400,000
432,070        410,000
436,415        420,000
438,019        430,000
443,280        440,000
443,375        450,000
446,952        460,000
447,806        470,000
449,127
449,967
450,260
463,056
463,435
463,767

What is wrong with this formula?

=countifs(A1:A14,>B1,A1:A14,<B2)
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
try

=countifs(A1:A14,">" & B1,A1:A14,"<" & B2)
Commented:
To make sure all values are counted you need one of the ">" or "<" to include an =, otherwise any value in column A that falls exactly on the boundary, e.g. 420,000, won't fall in any bucket. so a small modification to Thomas's suggestion...

=COUNTIFS(A:A,">="&B1,A:A,"<"&B2)

regards, barry

Experts Exchange Solution brought to you by