finding 1 formula result in a group of cells
Provided the number is positive.
Otherwise
=Sum(YourTenCellsAddressRange)
--
Steve
"AltaEgo" <Somewhere@NotHere wrote in message
...
If the other cells results are blank, you might try
=Max(YourTenCellsAddressRange)
--
Steve
"Richdg" wrote in message
...
I have ten cells in a row that have a formula in each. Only one of the
cells
will display a result at any one time but it changes depending on the
date. I
need a formula that will find the cell displaying the result and display
it
in a single cell in another worksheet
|