Excel Formula Help in Numbers
I have a formula that works great in Excel, and that I have not been able to re-write it to work in Numbers. Here it is.
I realize that everone one of these individual formulas are supported in Numbers, it seems to be the nested INDIRECT portion causing the grief. When I try to open this in Numbers I get a message saying the formula is not supported, and it has pasted the last values.
Is there a way to write this formua to to work in both Excel and Numbers?
If you are curious, this formula is writen to SUM a variable range of values between BarCodes (containing the $). The value string that needs to be summed can be as short as 1 value between each bar code, and up to 15-20 rows or values between.