How to make a report having 2 Columns and Total.

K

Kate

I want to make a report which has ColumnA and ColumnB.
ColumnA has 10 records. ColumnB has next 9 records.And
the last record in ColumnB has total of record 1 through
19.

ColumnA ColumnB
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
10 Total(1-19)

I think Multi column is easy to make using sub data sheet.
But how can I put the total in last record ?

Any help would be greatly appreciated.

Thanks,
Kate
 

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

HELP: Match values from different sheets and populate a column 3
How to choose maximum value 7
max 7
Auditing excel for everyday tasks 6
Copy Row to Sheet If Column Value is between time frame 8
return values in the table with multiple conditions 2
Problem formatting dates from CSV file 2
Make Y-axis values correspond to x- axis value 1

Top