In message <[log in to unmask]>,
[log in to unmask] writes
> I have a question regarding the SUMIF Function.  Using the example
>below.  I need to be able to add Mike John and Larry's totals to one
>cell.  Here is what I tried with no luck.
>
>=SUMIF(E3:E11,"=Larry""=Mike""=John",D3:D11)
>=SUMIF(E3:E11,"Larry""Mike""John",D3:D11)
>
>Neither of these work.
>
>Does anyone have any ideas as to how to get this to work?
>
>Thanks,
>Erik

=SUMIF(E3:E11,"<>Bill",D3:D11)

And yes, it *is* a little context-dependent.... :-)

But the way you have to look at SUMIF is, for each cell, and for

        criterion = ["][relational-operator] literal["]

(where the quotes are either both present or neither present)

        IF(cell {= or [relational operator]} ["]literal["],sum-cell,0)

e.g. IF(E3<>"Bill",D3,0)

so if 'criterion' cannot be expressed in a way that would fit in that
constructed IF, it cannot be done.

You could add an extra column that tested
         =IF(OR("Larry","Mike","John"),"Y","N")
and then SUMIF on "Y"...

but by then, you might as well bring the value or 0 over, instead of the
"Y", and do a straight SUM....
--
Roy Brown        'Have nothing in your houses that you do not know to be
Kelmscott Ltd     useful, or believe to be beautiful'  William Morris

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *