# how to print (find) negative amount in column E

#### illias

##### Member
 A B C D E 1 Jan-19 Feb-19 Mar-19 Apr-19 Print Negative amount only 2 306.85 339.72 328.77 (19,517.81) 3 (3,637.60) 4 (11,813.22) 5 (17,368.15) 6 126.58 140.14 (14,644.32) 7 165.93 183.71 (12,358.73) 8 169.92 188.12 (20,842.24) 9 421.54 466.69 (23,876.90) 10 887.64 982.74 (56,639.78) 11 1,396.70 1,546.35 (57,564.05) 12 383.57 (4,342.47) 13 472.58 (27,033.06) 14 (20,107.97) 15 (17,730.11) 16 (25,178.63) 17 (18,354.52) 18 (18,205.60) 19 (63,646.46) 20 (22,085.59)

#### Marc L

##### Excel Ninja
Just using IF worksheet function within a formula, at very beginner level just reading Excel help …​

#### illias

##### Member
what is the formula

#### Marc L

##### Excel Ninja
A better way : see the MIN worksheet function in Excel help …​

#### bosco_yip

##### Excel Ninja
Maybe,

In E2, copied down :

=IFERROR(AGGREGATE(15,6,-TEXT(\$A\$2:\$D\$20,";0.00;;"),ROW(A1)),"")

Regards
Bosco

#### Marc L

##### Excel Ninja
Hi Bosco !​
For a beginner an easy formula : =MIN(A2:D2) …​

#### Peter Bartholomew

##### Well-Known Member
Slightly more complicated
= SUMIFS( Table1[@], Table1[@], "<0" )
Any difference would only be apparent if there were either no negative values or multiple negative values.

Excel is still very limited when it comes to handling 2D arrays though; still stuck with single cell thinking!
= MMULT( IF(Table1<0, Table1, 0 ), {1;1;1;1} )
gives a 'proper' array result but is hardly the world's formula of choice.
= SEQUENCE( n, 1, 1, 0 )
will replace the array constant in time.

#### illias

##### Member
t
Hi Bosco !​
For a beginner an easy formula : =MIN(A2:D2) …​
thank you very much