How do I sum up random cells

  • Thread starter Thread starter Josh W
  • Start date Start date
Hello Martin,
What if one of the cells in the range has a value of #N/A? How can your
suggestion be modified so the sum() is not broken?
Thanks,
Joe
 
Hello Spiky,
What if there are #N/A values in your cell range? Any way to prevent the
SUM() function from skipping those?
Thanks,
Joe
 
Hi Gord,
What if there are some cells with the value of #N/A? What could be done so
the Sum function skips those and continues to sum the remaining cells in the
selection?
Thanks,
Joe
 
Hi Lori,
What if one of the cells in the selection has a value of #N/A? Is there any
way that the Sum function can disregard those and still provide a total of
the good cells in the selection?
Thanks,
Joe
 
Back
Top