How to get average of column of grid in case of null entry?

Question

I want to get the sum and also the average of GridView column .If there is any "null" entries in the column then it is not give me the sum.

int i = 0;
int j = 0;
int sum = 0;
try
{
for (i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (j = 0; j < dataGridView1.Columns.Count; j++)
{
sum = sum + (Convert.ToInt32(dataGridView1.Rows[i].Cells[j].Value));
}
}
MessageBox.Show("sum"+sum);
}

I want to get average of the column and then place it in the null value cell.

any body help me

Raghav Jhavar · Answer

Hi Suppose your column number you want to get sum of and average is '1': You can do: int sum = 0; int avg = 0; int rowCount = 0; //this part calculates sum foreach(DataGridViewRow DR in dataGridView1.Rows) { sum = sum + dataGridView1.Cells[1].Value; } Console.WriteLine(sum); //this part calculates average foreach(DataGridViewRow DR in dataGridView1.Rows) { rowCount += 1; } avg = sum / rowCount; Console.WriteLine(avg); //place average in null cell foreach(DataGridViewRow DR in dataGridView1.Rows) { if(dataGridView1.Cells[1].Value == null) { dataGridView1.Cells[1].Value = avg; break; } }

Ranjit Powar · Answer

try { for (i = 0; i { for (j = 0; j { if(dataGridView1.Rows[i].Cells[j].Value!=null) { sum = sum + (Convert.ToInt32(dataGridView1.Rows[i].Cells[j].Value)); } } } MessageBox.Show(sum+sum); }