Excel formula too long

Hi,
My problem is that I want to use SumIF(Cell A,"=30",Cell B)+SumIF(Cell A,"=40",Cell C) etc. I want to continue this formual across the entire workbook until I reach (Cell A,"=2500",Cell IV) some 250 cells later. The problem I have is that excel wont allow me past Cell AU leaving me some way short of the formula I require. Another of the problems I have that entering all these cells manually will take me days to do is there another faster way to do this ?? I would appreciate any help you could give me with this query Many Thanks Andrew