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?
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?