How to sum up values from sub-rows in worksheets

[kwik]

Hi

Do anyone know an easy way to sum up values in a worksheet? I have a worksheet that reports Areas from Polylines, and the total area is summed up and is easily displayed in the worksheet as well. But I would also like to sum up parts of the worksheet-values, only some of the sub-rows. For  example I have tried to sum up the area of the polylines R4a to R4d below, but it only returns the total area for all the sub-rows 3.1 to 3.12. Se also attached file for details

Sum of sub-rows.vwx

[Tom W.]

I don't think you can do this because the cells are dynamic in a database report. You could construct it as a criteria report instead using spreadsheet cells then you'll be able to do what you want e.g. first cell would be =AREA(N='R4a') etc. Be interested to know if there are any other options...?