is it possible to have muti-columes range in the sumif formula
e.g =sumif(a1:c5,xxx,xxx)

then have multiple criteria?
e.g =sumif(xxx, first colum equals "a" & second colum 1000, xxx)

how should i write it?

thx


--
vincent135
------------------------------------------------------------------------
vincent135's Profile: http://www.excelforum.com/member.php...o&userid=35373
View this thread: http://www.excelforum.com/showthread...hreadid=551836