jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
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
e f g
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
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