View Single Post
  #1   Report Post  
Watercolor artist
 
Posts: n/a
Default Need a formula that sums a column but could exclude some cells

In column F, from F5..F30, I have a set of dollar amounts that I want to sum.
However, if the value in cell K1="no" then I do not want to include in the
sum any value in column F that has in the same row the value "House" in
column I.

Howard