SUMIF's resulting in a positive number

[EmmaTM]

Hi,

I am using the following SUMIF:

=SUMIFS('[Vals 31.10.21.xlsx]ALL'!$D:$D,'[Vals 31.10.21.xlsx]ALL'!$A:$A,C44,'[Vals 31.10.21.xlsx]ALL'!$B:$B,A44)-D44

I am taking the difference between the SUMIF & the original value in D44 to see if the number has increased or decreased, in this cell I only want to see if it has increased. So if the result is a negative I want it to display 0

Thank you

 

[RoryA]

You could add MAX:

=MAX(0,SUMIFS('[Vals 31.10.21.xlsx]ALL'!$D:$D,'[Vals 31.10.21.xlsx]ALL'!$A:$A,C44,'[Vals 31.10.21.xlsx]ALL'!$B:$B,A44)-D44)

 

[EmmaTM]

Thank you very much