Hello Experts!

I usually post for help in the programming section.

I'm looking for a formula that looks at a range of cells (say A1:A20)
and retrieves the value within that range.

In those ranges, each cell has a formula that will return a value if
the criteria is true. In those ranges there will only be one number,
because only one can be true at a time. I just need to get that value
in another cell.

I tried to do =sum(A1:A20), but the formula doesn't recognize the
values as numbers (I guess).

Any help, much appreciated,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=553291