software

I want to sum a list of cells that have condition formulas that return a
value (1, 2 or 0) based on data in other cells. Because the data in these
cells is not actually a number, it just shows a number - the sum function
doesn't work. Is there anyway around this?

=SUMPRODUCT(SUMIF(A1:A20,{1,2,0}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Brad Larsenquot; lt;Brad gt; wrote in message
...
gt; I want to sum a list of cells that have condition formulas that return a
gt; value (1, 2 or 0) based on data in other cells. Because the data in these
gt; cells is not actually a number, it just shows a number - the sum function
gt; doesn't work. Is there anyway around this?
Why aren't they numbers? Do you have a formula like this?
=IF(A2lt;10,quot;1quot;,IF(A2=10,quot;2quot;,quot;0quot;))
Where the numbers returned are in quotes? If so, just remove the quotes and
they will be numbers that you can sum. If you can't do that, perhaps this
array entered formula (entered using Cntl-Shift-Enter rather than just Enter)
will work:
=SUM(VALUE(B2:B5))

--
Kevin Vaughnquot;Brad Larsenquot; wrote:

gt; I want to sum a list of cells that have condition formulas that return a
gt; value (1, 2 or 0) based on data in other cells. Because the data in these
gt; cells is not actually a number, it just shows a number - the sum function
gt; doesn't work. Is there anyway around this?