I have a listing of customers, and their daily deposits. In the colums b-e i
have a break down of what range their deposit fell into.

Column B is 0-25
Column C is 26-100
Column D is 101-500
Column E is 501

I want the pivot table to count each company's totals for each range of
deposits but it is not working. It seems to be counting the same colums for
each range. Can any one suggest anything that i might be doing incorrectly?

Thanks