Sorry, don't want to confuse you with multiple suggestions :( but....

This formula, which only requires ENTER is, another way to go

=SUM(SUMIF(A1:A100,{"dept a","dept b"},B1:B100))

array entered, i.e. using CTRL+SHIFT+ENTER, you can also use the above
with a named range

=SUM(SUMIF(A1:A100,midwest,B1:B100))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564037