Add cells in column depending on value of cells in another column
 

One column has the status (open or closed). Another column has a $ amount.
I want to be able to sort on any column and still have a total of each
status. I tried =Sum(G2:G358)*If(F2:F358, "Open") - but that did not work.

Add cells in column depending on value of cells in another column
 

try
=sumif(f2:f358,"Open",G2:G358)

"CDBallard" wrote:

One column has the status (open or closed). Another column has a $ amount.
I want to be able to sort on any column and still have a total of each
status. I tried =Sum(G2:G358)*If(F2:F358, "Open") - but that did not work.