jammer6_9
01-11-2009, 02:25 AM
=SUMIF(F5:F35,"<>NULL",B5:B35)
:help I want to sum a range when it is not null? I tried above formula but still summing all cell ranges.
:help I want to sum a range when it is not null? I tried above formula but still summing all cell ranges.