Do you mean that you are trying to store 2 pieces of information, the number 1
and the text CE, in the same cell?

As evidenced by Alladin's formula, you will make your life much easier if you
put the 1 in A4 and the CE in A5.

Then you could use =SUMIF(A5:D5,"CE",A4:D4)

On Wed, 26 Jan 2005 13:41:03 -0800, Carole
wrote:

I want to have a formula that I can put into cell P4, Q4, and R4 that will
sum the range "A4:D4" that contain the text "CE", "LS", and "LA". I have
tried variations of sum, sumif, and sumproduct, that also included
substitute, none seem to give me the answer. They either give me an error or
"0".
A4 = 1 CE
B4 = 1.5 LS
C4 = 1 LA
D4 = 2.25 CE
Please help!