With names in column A, and amounts in column B, put this in C1 to total all
of column B except those amounts relative to John, bush, and kaven.

=SUM(B1:B10)-SUMIF(A1:A10,"john",B1:B10)-SUMIF(A1:A10,"bush",B1:B10)-SUMIF(A1:A10,"kaven",B1:B10)

Vaya con Dios,
Chuck, CABGx3



"b166er" wrote:

>
> members,
>
> can i give criteria range for sumif funtion i tried but i couldn't give
> criteria range.
>
> if criteria range can not be given then how can we use or command to
> give more than one arguments say i want sum in col B5 all the the sale
> made by either of three salepersons(john,bush,kaven).
> i dont mind if someone tell me some other function through which i
> could solve that problem.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=553244
>
>