This should be simple

[Spreadsheet]

I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not contain values. If only one of the cells contains a value, I want this value to appear in B1. How can this be done?

[Dave Peterson]

You have a response in .excel

Spreadsheet wrote:
>
> I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
> contain values. If only one of the cells contains a value, I want this
> value to appear in B1. How can this be done?
>
> --
> Spreadsheet
> ------------------------------------------------------------------------
> Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
> View this thread: http://www.excelforum.com/showthread...hreadid=557389

--

Dave Peterson

[Gary''s Student]

Try:

=IF(COUNT(A1,A3,A5,A7,A9,A11)=1,MAX(A1,A3,A5,A7,A9,A11),"")
--
Gary's Student


"Spreadsheet" wrote:

>
> I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
> contain values. If only one of the cells contains a value, I want this
> value to appear in B1. How can this be done?
>
>
> --
> Spreadsheet
> ------------------------------------------------------------------------
> Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
> View this thread: http://www.excelforum.com/showthread...hreadid=557389
>
>

[Spreadsheet]

Thanks, that works.