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