View Single Post
  #1   Report Post  
René
 
Posts: n/a
Default How do I sum an array of cells, even if some of them are #N/A

I have a table where I lookup working hours in a "Incident reporting sheet"
I want to sum these hours per week. Some of the cells are invalid (#N/A),
because there were no incidents that day. But then I can't get the sum for
those specific weeks. How do I ignore the invalid cells in summing those
arrays?