Hello,
I have an issue with #VALUE! appearing in cells where calculations are not always present.
On sheet 2 when i change from my 2 options in the drop down list located in A2 I have a sum formulae in cell G2, however when changing between my 2 sets of data the sum formulae doesnt work and displays the error message as one set of data has more rows of information than the other.
is there a way to hide the #VALUE! so my sum function in G2 always works.
Ive attached my spread sheet to show my issue.
Bookmarks