Nested if-function - autosum

Ok, let me start to describe what I want to do, and then how I've tried to solve the problem.

I basically need a function that can do an autosum of 1-30 cells in a row. I know this can be achieved manually, but the point is to do this automatically.

I've tried to solve this with a nested if-function, but as you might know (and as I dicovered), excel has a limit of 7 nested functions and I need about 30 levels to do what I want to do... There is probably a better way to do this with VBA, but I have limited experience with programming, so I need some help...

You'll find my excel file attached.

I hope there's someone out there who can help me...

Regards,

Vidar V.

I would suggest you remove all the blank rows and populate, for EVERY row, Col A and col B with part 1 , 1.00 etc.

Then use a sumproduct approach to add up all the numbers in col H against the relevant part number and area.

In effect you would be creating a new summary table from your raw data.