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