Thread
:
Ignoring #N/A in an Autosum range
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Jaye
Posts: n/a
Ignoring #N/A in an Autosum range
I need to be able to add data in a column, and some of the cells in that
column have an #N/A in it, resulting from a VLOOKUP. How do I add the data in
the column, and have it ignore the #N/A?
Reply With Quote
Ignoring #N/A in an Autosum range