Hi Dave

Try
=SUMIF(T1:T100,"<",U1:U100)

--
Regards

Roger Govier


"DaveMoore" wrote in message
ups.com...
I want to add values in column 'U' if the adjacent cell in column 'T'
is not equal to null.
How can I do this?
I have experimented with both SUMIF and SUMPRODUCT but without
success.
Can anybody help?