NULL Values

[Guest]

I

I'm trying to use the function SUMIF() But i'm encountering problems, i
want to sum if the cells are not empty, but i can't figure it out how i do
that:

SUMIF(a1:a2;not null;b1:b2)

This don't work

Neither: SUMIF(a1:a2;<>null;b1:b2)

Urgente help

With the best regards

Hugo Gomes

 

[Guest]

Try something like:

=SUMPRODUCT(--(L86:L93<>""),--(M86:M93))