Ignore Sum(K:K) If cell B2 is blank.

[tazmtiger]

Hi!

How do I tell cell (b3) to not sum(k:K) if cell b2 is blank, or has no value?


Please! Help.

Thank you!

 

[MrKowz]

=if(b2<>"",sum(K:K),"")

 

[VoG]

Hi. Try

=IF(B2="","",SUM(K:K))

 

[tazmtiger]

=if(b2,sum(K:K),"")

I need it to do the opposite.

I need it to ignore calculation on "B3" which is Sum(K:K) when there is nothing in cell B2.

Thanks!

 

[VoG]

Did you try either formula?

 

[tazmtiger]

Did you try either formula?

I am sorry!

I missed the -> "") part after the sum(K:K).

Thank you!

That worked.