Sum with conditions

[Mark S]

Hello all,

I've got a small problem. I have sheet with about 10 colums. I need
to be able to sum a column with conditions tho

Sum Column 1 if Column 2 has the letter "N" and if Column 3 is not blank..

Any Ideas??

Thanks
Mark

 

[JE McGimpsey]

one way:

=SUMPRODUCT(A1:A1000,--(B1:B1000="N"),--(C1:C1000<>""))



for and explanation of the usage of "--", see

http://www.mcgimpsey.com/excel/doubleneg.html