C#

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;

namespace ListView
{
    public partial class Form1 : Form
    {
        XmlTextReader reader;
        XmlDocument doc = new XmlDocument();
        StringCollection foldercol = new StringCollection();
        ImageList ilLarge = new ImageList();
        ImageList ilSmall = new ImageList();
        private System.Windows.Forms.ListView list = new System.Windows.Forms.ListView();
        Label lbl = new Label();
        Button b = new Button();
       
        public Form1()
        {
            InitializeComponent();
            CreateHeadersAndFillListView();
            String sss;
            PaintListView(sss);   
        }

        private void InitializeComponent()
        {
            button1.Click += new EventHandler(button1_Click);
            // list.ItemActivate += new EventHandler(list_ItemActivate);

        }

        private void CreateHeadersAndFillListView()
        {
            ColumnHeader colHead;

            colHead = new ColumnHeader();
            colHead.Text = "Filename";
            this.list.Columns.Add(colHead);

            colHead = new ColumnHeader();
            colHead.Text = "Size";
            this.list.Columns.Add(colHead);

            colHead = new ColumnHeader();
            colHead.Text = "Last accessed";
            this.list.Columns.Add(colHead);
        }

        private void PaintListView(string sss)
        {
            try
            {
                ListViewItem lvi;
                ListViewItem.ListViewSubItem lvsi;

                this.lbl.Text = sss + "(Double click to display the path name)";
                //DirectoryInfo dir = new System.IO.DirectoryInfo(root);
                //DirectoryInfo[] dirs = dir.GetDirectories();
                //FileInfo[] files = dir.GetFiles();

                this.list.Items.Clear();
                this.list.BeginUpdate();

                reader = new XmlTextReader("path.xml");
                Form1 f = new Form1();
                while (reader.Read())
                {
                    switch (reader.NodeType)
                    {
                        case XmlNodeType.Text: //Display the text in each element.
                            //   Console.WriteLine(reader.Value);
                            String s1;
                            s1 = reader.Value;
                            String ss;
                            ss = listBox1.SelectedItem.ToString();
                            sss = ss + s1;
                            object o3 = (object)sss;

                            DirectoryInfo dire = new DirectoryInfo(sss);
                            if (dire.Exists)
                            {
                                String[] folder;
                                folder = Directory.GetDirectories(sss);
                                foreach (string foldername in folder)
                                {
                                    DirectoryInfo di = new DirectoryInfo(foldername);
                                    if (di.Exists)
                                    {
                                        String[] files;
                                        files = Directory.GetFiles(foldername);
                                        foreach (String filename in files)
                                        {
                                            FileInfo fil2 = new FileInfo(filename);
                                            lvi = new ListViewItem();
                                            lvi.Text = fil2.Name;
                                            lvi.ImageIndex = 1;
                                            lvi.Tag = fil2.FullName;

                                            lvsi = new ListViewItem.ListViewSubItem();
                                            lvsi.Text = fil2.Length.ToString();
                                            lvi.SubItems.Add(lvsi);

                                            lvsi = new ListViewItem.ListViewSubItem();
                                            lvsi.Text = fil2.LastAccessTime.ToString();
                                            lvi.SubItems.Add(lvsi);

                                            this.list.Items.Add(lvi);
                                            // listBox5.Items.Add(fil2.ToString());
                                        }
                                        this.list.EndUpdate();
                                    }
                                }
                            }

                            break;
                    }
                }

            }
            catch (Exception err)
            {
                MessageBox.Show("Error: " + err.Message);
            }

            this.list.View = View.Details;
        }


        private void button1_Click(object sender, EventArgs e)
        {
            //listBox1 lb = (listBox1)sender;
            string[] drives = Environment.GetLogicalDrives();
            // Loop into the string array
            foreach (string strDrive in drives)
            {
                // Add items (drives) to the list
                listBox1.Items.Add(strDrive.ToString());
            }
        }
    }
}

if (RECONCILIATIONIND == "N")
{
    objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
    objRange = objSheet.Cells.Rows.EntireRow;
    objRange.Font.ColorIndex = "3";
}

Nominees & Own Name (Level 1)	Beneficiaries (Level 2)
19326421	
	                                175
	                                84
	                                76
	                                2238
	                                235
	                                14
	                                591
	                                345
	                                122
	                                240
	                                346

                    if (RECONCILIATIONIND == "N")
                    {
                        objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
                        objRange = objSheet.Cells.Rows.EntireRow;
                        objRange.Font.ColorIndex = "3";
                    }
>/pre>
The next problem I have is that I need to do some calculation on an unknown number of cells and subtract it from a total in a different column.  Below is a sample screen.
<code>
Nominees & Own Name (Level 1)	Beneficiaries (Level 2)
19326421	
	                                175
	                                84
	                                76
	                                2238
	                                235
	                                14
	                                591
	                                345
	                                122
</code>
From the above, I need to calculate the totals in Beneficiary (level 2) and subtract that from Level 1 total and add the total into a new column.  Now, there is an undertermined number of values in Level 2 i.e. there could be 2 or 4 or 50 or 300 values to add.  How would I be able to do that?

Any help or advise would be appreciated. 

<div class="ForumSig">Excellence is doing ordinary things extraordinarily well.</div>