if error aggregate fuction

[jordanburch]

Hey all,

I have the below function. It seems to only return values from the first aggregate function. I want it to return from both functions if there are values. I have show more below.

=-(IFERROR(IFERROR(AGGREGATE(15,6,($G$4:$G$40)/($G$4:$G$40<>0),ROW(A1)),AGGREGATE(15,6*($B$4:$B$40)/($C$4:$C$40="Not in Idarrs"),ROW(A1)-COUNTIFS($G$4:$G$40,"<>"&""))),0))
a b c

21-3875.001-2 - ALC 5700

$ (110,336.00)

Not in Idarrs

e f g

21-3875.002-1 - ALC 2100

$ (13,724,309.61)

$ (13,713,219.06)

It successfully returns the 13 million value, but not the $110 value in b. I want the 13 million and the 110 to be in a list that I put the formula in column c. It seems like its only working for the first part of the formula and the second aggregate function doesn't pull the value. Basically I want it to look like the below

$13713219
$110336

Hopefully this makes sense. Any help is appreciated!

Jordan

 

[Fluff]

Whilst I have no idea what you are trying to do, you need to replace the * with a ,

 

[jordanburch]

that was the issue thanks FluFF!

 

[Fluff]

Glad it helped & thanks for the feedback.