Getting the specified formula cannot be entered because......... error

[neeraj15876]

I have attached a file in this thread and getting this error on adding formula for 29th column "the specified formula cannot be entered because it contains more values, references and/or names than are allowed in the current file format."
Please suggest solution or a squeezed formula.

[Andrew-R]

How about:

=COUNTIF(A3:AD3,"l")+(0.5*COUNTIF(B3:AD3,"c"))

[neeraj15876]

Thanks andrew pls share logic of below
1. 0.5*

[Andrew-R]

Your original formula was trying to add 1 for every time "l" appeared in the row, and add 0.5 every time "c" appeared.

The two COUNTIF statements count, respectively, how many l's and c's there are, but because each c adds only 0.5 to the final value you need to multiply the number of c's by 0.5 to get the correct answer.

[DarylKurt]

hi I'm getting the same error. what should i do?

[FDibbins]

Daryl, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[MarvinP]

Try this in AE3

=COUNTIF(A3:AD3,CHAR(108))+COUNTIF(A3:AD3,"c")*0.5

[FDibbins]

@ Marvin, you made the same mistake I did. This is an old post, and that last question was not from the OP lol