Formula to Sum Cells that Hold If Formulas

B

Brad Larsen

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?
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
K

Kevin Vaughn

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))
 
Top