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