See the screen shoot and help me to sum

Question

Here is my datagridview. I need the sum of AmountBDT where SuspenceAccount is Placid Express.

Sl	SuspenceAccount	AmountBDT
1	Placid Express	30
2	Prabhu Group	40
3	Placid Express	20
4	Ria Financial	70
5	Placid Express	50

Rafnas T P · Answer

try below code double sum = 0; foreach (DataGridViewRow g1 in dataGridView.Rows) { if (g1.Cells[1].Value.ToString()== Placid Express ) sum= sum+ Convert.ToDouble(g1.Cells[2].Value); } MessageBox.Show( Sum =  + sum ); here sum is your output

Shovan Saha · Answer

But getting problem such as: An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll Additional information: Input string was not in a correct format.

Yogendra Bhardwaj · Answer

int sum = 0; foreach (DataGridViewRow row in dataGridView.Rows) { if(row.Cells[0].Value=='Placid Express') sum += (int) row.Cells[2].Value; } MessageBox.Show(Sum of all the values is {0} sum.ToString());