How do I sum up random cells

[JAG]

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

 

[JAG]

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

 

[JAG]

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

 

[JAG]

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

 

[Ashish Mathur]

=sumif(range,">=0",sum_range)+sumif(range,"<=0",sum_range)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com