sumif

[erik550]

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?

 

[Roger Govier]

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

 

[erik550]

Thats it. Thanks a lot