This is not documented in the HELP files...

=SUMIF(O25:O55,"= P26",J25:J55) should be:

=SUMIF(O25:O55,"="&P26,J25:J55)

Does it work now?


--
swatsp0p


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