Summing multiple ranges based on criteria....

[Barking_Mad]

Hi,

I thought i'd cracked this but my formula doesn't seem to be working correctly, and it's a bit unwieldy (ie long!), so im hoping someone can offer a better solution...

I have 9 columns of numbers: A9:A200 across to: I9:I200. I have to work out the total number of values in those columns that fit the following criteria:

<40
40-49
50-59
60-69
70-79
80+

This is slightly complicated by the fact that should the value 39v appear in any of the columns, should be counted alongside the other numbers that are<40. Anyone any suggestions?