Formula to Sum Cells that Hold If Formulas

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

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brad Larsen" <Brad Larsen@discussions.microsoft.com> wrote in message
news:B3C863ED-A4F9-4405-ACE3-4CA74E0EEB01@microsoft.com...
> 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?

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

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