Sum calculation displays #value!

[Dom.Knight]

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.

[AliGW]

In H7 copied down:

=IFERROR(SUM(E7*G7),"")

Fix the other formulae in I and J in the same way.

[Dom.Knight]

Great Thanks

[AliGW]

No problem.

[mdbdesign]

Right time and right place, you save my corona, thank you Ali.

[AliGW]

As in your beer?

[mdbdesign]

That's right.