Help with count if function

[floricita]

Hi,

I have a table where one column (D) has a spend column.

I now need to count how many cells in column D fall into certain spend groups.

so the ranges are £1-£100,£101-£200 and so on until £1200.

For the first calculation I wrote the following forumla =COUNTIF($D$6:$D$457,">=1")-COUNTIF($D$6:$D$457,"<=100")

I then copied this down and changed the values according to the ranges.

But when I get to range 201-300 I start to get negative numbers returned, which doesn't make any sense to me, so I must be doing something incorrect along the way.

any help would be appreciated.

Thanks

[floricita]

Basically need to fill in the no of shops col in col g

[zbor]

Your data looks very close to Pivot table.

So use Pivot table rather then your range...
Then group ranges by 100

[floricita]

Thanks that is fantastic.

How did you group the ranges out of interest?

[floricita]

Ah, I have just seen the "group" option.

Thanks again for all your help