Generally, this how to concatenate the two:
=SUMIF(O25:O55,"="&P26,J25:J55)

But in this case, the below will be enough:
=SUMIF(O25:O55,P26,J25:J55)

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=389858