Greater Than or Less Than

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

Guest

I need help with a formula that says if Column K = A and Column B does not equal Open than Sum Col G

This is what I hav

=SUM(IF($K$2:$K$123="A",IF($B$2:$B$123<>"open",G2:G123

If I change the <> signs to =, it sums correctly. However using the <> brings a value of 0. What am I doing wrong? Thank
 
Hi
try
=SUMPRODUCT(--($K$2:$K$123="A"),--($B$2:$B$123<>"Open"),G2:G123)
note: This is case sensitive for 'A' and 'Open'

--
Regards
Frank Kabel
Frankfurt, Germany

Jan said:
I need help with a formula that says if Column K = A and Column B
Click to expand...
does not equal Open than Sum Col G.
 
Thanks but it still brings a value of $0. And just as in my formula if I change <> to = "open", it sums the data for all open projects. Is there a formula that says "SUMIF "A" does not eqal "open"?
 
Hi
this would indicate there's no mact for 'A' in the first column and
<>'open' in the other column. If you like email me your file and I'll
have a look at it as this formula should work
email: frank[dot]kabel[at]freeenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Jan said:
Thanks but it still brings a value of $0. And just as in my formula
Click to expand...
if I change <> to = "open", it sums the data for all open projects. Is
there a formula that says "SUMIF "A" does not eqal "open"?
 
Hi
glad to hear :-)
Just curious: what was the error?

--
Regards
Frank Kabel
Frankfurt, Germany

Jan said:
Frank
You are correct! The formula does work. I spoke too soon. Thanks for
Click to expand...
your help! Have a great weekend!
 
Back
Top