Hi,
I would like to perform a sum on a column with several numbers filled in from a VLOOKUP command, and several "#N/A's" from that same VLOOKUP that appears because the VLOOKUP field on those cells is blank. When I sum the column I get #N/A and not the sum of just those several numbers which is what I want.
Please help - thank you in advance.