ExcelBanter - SUMIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF (https://www.excelbanter.com/excel-worksheet-functions/141561-sumif.html)

DaveMoore

SUMIF

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

SUMIF

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?

DaveMoore

SUMIF

On 4 May, 08:11, "Roger Govier" wrote:
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?- Hide quoted text -

- Show quoted text -

Thank you Roger, worked brilliantly.

All times are GMT +1. The time now is 10:36 PM.