Formula to Sum Cells that Hold If Formulas
 

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?

Formula to Sum Cells that Hold If Formulas
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brad Larsen" <Brad wrote in message
...
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?

Formula to Sum Cells that Hold If Formulas
 

Why aren't they numbers? Do you have a formula like this?
=IF(A2<10,"1",IF(A2=10,"2","0"))
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 Vaughn


"Brad Larsen" wrote:

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?