View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dyer Dyer is offline
external usenet poster
 
Posts: 1
Default How to sum number values, excluding data returned #N/A during Vloo

My question is how due I sum all values in a column that have a numerical
value, and exclude the data in the same column returned #N/A. For example
the database hase the following data;
19.40
17.93
#N/A
2,002.41
322.82
#N/A
8.39

I need to sum over 3888 cells in one column to get a grand total of values,
not #N/A.
Thanks for the assistance.