Formula help

[Aaron Neunz]

I have a range of cells E10:E20. There is going to be a dollar amount in
only one cell of that range. Can someone help me with a formula that will
scan the range of cells and return the dollar amount (wherever it may be)?

Thanks,
Aaron Neunz

 

[Niek Otten]

=SUM(E1:E10)

 

[Sandy Mann]

If it is the only number in that range then try:

=SUM(E10:E20)

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Bernard Liengme]

What will be in the other cells?
Text, numbers not formatted to $, ?????
tell us more and we'll try to help