"candylj" wrote...
I have created a spreadsheet using vlookups. If a cell is blank, the other
cell returns #n/a. However, a total may be in another cell. I am adding
two
sets of information in another cell. If one cell has a number and other
has
n/a, it returns n/a instead of the total number. The help screen for n/a
says use brackets (), but it does not make any sense. SUMIF, IF, COUNTIF
has not worked to get the End Total to add when there is a #n/a in the
sub-total fields.
....

Better to fix the VLOOKUP formulas so that instead of

=VLOOKUP(a,d,c,0)

which could return #N/A, you use an IF test as well, like

=IF(ISNA(VLOOKUP(a,b,c,0)),"",VLOOKUP(a,b,c,0))

but next best would be using SUMIF to sum the range of these formulas.

=SUMIF(d,"<#N/A")