Hi all,
I have the following data:
<tbody>
</tbody>
I am trying to write a formula for column D which takes the average of the child SKUs, however, I keep getting #Div/0.
Formula in column D:
=IF(B1="Parent",AVERAGEIFS(C:C,A:A,left(A1,5),B:B,"Child"),C1)
All data in Column A is TEXT and must remain so.
Some troubleshooting has shown that the "A:A,Left(A1,5)" criteria is causing the error, but I can't understand why......
Any thoughts on what is going on here and how to fix?
Thanks
I have the following data:
A | B | C | D | |
1 | 12345 | Parent | 10 | #Div/0 |
2 | 12345A | Child | 5 | 5 |
3 | 12345B | Child | 10 | 10 |
4 | 12345C | Child | 20 | 20 |
<tbody>
</tbody>
I am trying to write a formula for column D which takes the average of the child SKUs, however, I keep getting #Div/0.
Formula in column D:
=IF(B1="Parent",AVERAGEIFS(C:C,A:A,left(A1,5),B:B,"Child"),C1)
All data in Column A is TEXT and must remain so.
Some troubleshooting has shown that the "A:A,Left(A1,5)" criteria is causing the error, but I can't understand why......
Any thoughts on what is going on here and how to fix?
Thanks
Last edited: