sumif results shows opposite

[asyamonique]

=SUMIF(Sheet1!$CI$3:$CI$2000,Sheet2!$C3,Sheet1!CU$3:CU$2000)

Hello,
Is it possible to add to above formula those below conditions?
Thanks

If sum result is positive => Sum result will be negative
If sum result is negative => Sum result will be positive

 

[Joe4]

Just multiply by -1, i.e.

=-1*SUMIF(Sheet1!$CI$3:$CI$2000,Sheet2!$C3,Sheet1!CU$3:CU$2000)

 

[asyamonique]

Thanks.

 

[Joe4]

You are welcome.