sumif function

[dolphinv4]

Hi,

I tried to use the sumif function =sumif(range,criteria,
[sum_range]).

For the "criteria", I wanted it such that it'll sum if
the "range" is not equals to cell A1 or B1. I tried =sumif
(d1:d10,not(or(A1,B1)),e1:e10) but it does not work. why?
and it's not supposed to be done this way, how shld i go
about doing it?

val

 

[Biff]

Hi Val!

Sumif will take only a single criteria. Try either of
these:

=SUMIF(D110,"<>"&A1,E1:E10)-SUMIF(D110,A2,E1:E10)

=SUMPRODUCT(--(D110<>A1),--(D110<>A2),--E1:E10)

Biff

 

[JE McGimpsey]

Niggle:

There's no need to use the unary minuses on the E1:E10 argument:

=SUMPRODUCT(--(D110<>A1),--(D110<>A2),E1:E10)