SUMIF

[DaveMoore]

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?

 

[Roger Govier]

Hi Dave

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

 

[DaveMoore]

Hi Dave

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

--
Regards

Roger Govier






- Show quoted text -

Thank you Roger, worked brilliantly.