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=553245