=sumif(range,"=0",sum_range)+sumif(range,"<=0",su m_range)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"JAG" wrote in message
...
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
"Lori" wrote:
Martin - the brackets just mean it is a multiple selection. Use the INDEX
function to pick out a particular range e.g. =INDEX((A1,B2,C3),,,2).
Multiple ranges can be used inside most summary functions as well as a
few
others. The number of areas allowed in functions appears to be 32768
before
running out of memory - although the maximum number of areas you can
select
on a sheet is limited to 8192. So in practice the formula length limit
will
easily come first.