I am not sure why it does not work. For one thing, it links to another
spreadsheet, assuming that is allowed. What about the values that I
have asked for, the SECY and 211? Is it critical on the format or
something?

How about an alternative? Two SUMIF's back to back?

Rich


--
rjmat
------------------------------------------------------------------------
rjmat's Profile: http://www.excelforum.com/member.php...o&userid=17548
View this thread: http://www.excelforum.com/showthread...hreadid=482248