Thread: Add cells in column depending on value of cells in another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CDBallard CDBallard is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote