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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top