Hi erik
Try
SUMIF(E:E,"="&B2,I:I)


--
Regards

Roger Govier


"erik550" wrote in
message ...

Hi,

SUMIF(E:E,"=2",I:I)

For this function is it not possible to swap the =2 to =b2 so that
my
logical test is based on a certain value in a cell?


--
erik550
------------------------------------------------------------------------
erik550's Profile:
http://www.excelforum.com/member.php...o&userid=32086
View this thread:
http://www.excelforum.com/showthread...hreadid=518613