Summation of columns of varying heights?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need some help here. I have data that has records in Rows. There is a
cost column that I need to sum up but the range of the fields varies.
Fortunately, the height of each range is provided. As an example:

Row 1, Column N has number of rows below to be summed: 4
Rows 2-5, Column P needs to be summed per N1
Row 6, Column N has number of rows below to be summed: 18
Rows, 7-24 Column P needs to be summed per N6
and so on...
Also, for items to be summed, their Column N is always 0 (zero).

any ideas how to do this?

Thanks,

Jeff
 
With first cell of column M or O (or another unused column), use the formula
=IF(N1=0,"",SUM(OFFSET(N1,1,2,N1,1)))
and just copy formula down as far as needed.

-Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable range column summation and averaging 2
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Conditional SUBTOTAL in XL210 Table 7
How do I sum a column based on 2 different column headers/criteria? 0
Variable row groupings 3
Summing a variable number of rows 3
Sum portion of column based on row content 2
Macro-total a column with different row sizes 1

Back
Top