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

mingandmong

Active Member
Joined
Oct 15, 2014
Messages
339
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)
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

mingandmong

Active Member
Joined
Oct 15, 2014
Messages
339
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,072
Messages
5,526,640
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top