PDA

View Full Version : Solved: SUMIF "CELL IS NOT NULL"



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.

Bob Phillips
01-11-2009, 04:33 AM
Try

=SUMIF(F5:F35,"<>",B5:B35)

jammer6_9
01-11-2009, 05:04 AM
I thought I have tried that :think: ... That works!