I have a formula in a cell(A) that reads the information from another cell(B)
using the Vlookup function. However, some of these B cells contain a formula
with no results in them, resulting in A displaying the #VALUE! error. is
there a way to ignore those cells that contain no values?

I am also trying to add up all of the A cells but obviously get the #VALUE!
as a result because of the previous errors. Anyway to count these VALUE
cells as zero or circumvent in any way?

thanks