Need a formula that sums a column but could exclude some cells

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

Guest

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
 
try
=if(K1="no",sumproduct(--(I5:I30<>"House"),F5:F30),Sum(F5:F30))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Is it possible to SUM based on value of another column? 3
How to set cell value to emptry if three other columns are empty too 1
Dsum Help 0
Really need some help with a multi conditional SumProduct 1
sum of multiple rows 2
total a column in which there are sum formula 4
Having cells default to 0 2

Back
Top