displaying positive numbers as negative numbers or merge my 2 formulas that work

[mingandmong]

Hi

im using excel 2016

i have 2 formulas that work, can somebody merge them into only 1 formula the first formula resides in T10

1) =SUMIF(L4:L39, "IRISH", J4:J39)

2) =T10*-1

result was 669 then -669


tried example

=SUMIF(L4:L39, "IRISH", J4:J39,*-1)

 

[Eric W]

Try:

=-SUMIF(L4:L39, "IRISH", J4:J39)

 

[mingandmong]

why do we over complicate things in life.. when the truth is quite simple

thanks Eric..your a genius it worked so simple when you know how

 

[Eric W]

Glad to help, thanks for the feedback.