Remove #VALUE!

[RodneyW]

I have this formula on cell G200. =G17+G51+G85+G119+G153+G187

If any of the cells referenced in the formula are empty, #VALUE! displays. What I need to have happen is for G200 the results from the above formula to total everything where there is a value. Lets say the values in the cells referenced above are: 10, 20, 30, 40, 50 and the last cell G187 doesn't have a value. G200 should display 150 (the total of 10+20+30+40+50).

Cells G17 etc all have formulas similar to this:

=IFERROR(VLOOKUP($B$6,'D:\Corporate\Analytics\2019 Analytics\Final2019\[NewsLettersNov2019.xlsx]Stations'!$A$3:$FN$208,IF($C$6="CCM",120,IF($C$6="CTT",59,IF($C$6="NT",92,155))),FALSE),"")

How can I get rid of the #VALUE! error?

 

[RoryA]

Use SUM instead:

=SUM(G17,G51,G85,G119,G153,G187)

 

[Fluff]

Use
=SUM(G17,G51,G85,G119,G153,G187)

 

[RodneyW]

This worked =SUM(G17,G51,G85,G119,G153,G187) thank you

 

[Fluff]

Glad we could help & thanks for the feedback