Ive got an excel file with a lot of line items and cant get a subtotal or sum at the bottom of some columns, instead I get #Value!.
Googled this to find a statement that this happens with a 3D reference.
Not sure if this is true and if I have a 3D reference. Nonetheless there are no suggestions how to resolve.
Hope someone can help find smart solution.