How can I sum for conditional column

Question

var sumObject = dataGridView1.Rows.Cast () .Sum(row => row.Cells[AmountBDT].Value.ToString() SuspenceAccount = Placid Express); Here two column : AmountBDT & SuspenceAccount. Placid Express is one of the item of SuspenceAccount.

Ashish Vishwakarma · Answer

I am assuming Sum() you are applying on a list of Integer Sum() is taking a Func parameter typically with overloads like Func or Func you can put your condition in lambda whatever you needs to be added like below row =>{ if(Your Condition) { return row.Cells[AmountBDT].Value.ToString(); } } You can modify according to your datatype and need find implementation details here https://github.com/dotnet/corefx/blob/master/src/System.Linq/src/System/Linq/Sum.cs