try
=if(K1="no",sumproduct(--(I5:I30<"House"),F5:F30),Sum(F5:F30))
"Watercolor artist" wrote:
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
|