Hi,
I would appreciate a little help if possible. I would like to sum variable number of rows. The sheet will have around 10 populated data columns and I would like to sum on one of the value columns.
My issue is the sum appears below the detail held in the 10 columns. Therefore if I show only the sum value all the detail in the other 8 columns is blank. I would like to see say 9 identical rows condensed into a single row (showing data in each column) with a single sum value.
The type of exercise to sum a purchase order with many transactions associated.
Thank you for your help.
Kevin
I would appreciate a little help if possible. I would like to sum variable number of rows. The sheet will have around 10 populated data columns and I would like to sum on one of the value columns.
My issue is the sum appears below the detail held in the 10 columns. Therefore if I show only the sum value all the detail in the other 8 columns is blank. I would like to see say 9 identical rows condensed into a single row (showing data in each column) with a single sum value.
The type of exercise to sum a purchase order with many transactions associated.
Thank you for your help.
Kevin