Sum selected rows in datatable only?

Question

I have a datatable which has an amount column & a status column. I want to sum only those rows who have status '1'. How to do this? I am summing the column via datatable Compute method.

Answer 1

dataTable.Compute("sum(amount)", "status = 1")