View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default How do I sum up random cells

=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.