How do I sum up random cells
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.
|