Does this do it

=COUNTA(G7:O7)&"P"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sungen99" wrote in
message ...

Here is what I need to be able to do.

I have 9 columns of clients account numbers as the header.
Each row is a trade that belongs to one of the 9 accounts.

I need to have the 10th column have the account the trade is for
written.

So for example I think I want to do something like this:
If G7 <"" then make P7="1P"
Or
If H7 <"" then make P7="2P"
Or
If I7 < "" then make P7="3P"

And so on.

Just don't know how to do it.

Thanks in advance,
Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117