Click here for important information about Computing.net.

Dell / Inspiron 17r

I tried copying and pasting (formula) an existing array formula into a different cell and that did not work. I then pressed Control-Shift-Enter and retyped the array formula and that didn't work. I then retyped the array formula and then pressed Control-Shift-Enter and that didn't work. What am I doing wrong? Thank you.

Brian W

re: "I tried copying and pasting (formula) an existing array formula into a different cell and that did not work."What does "that did not work" mean?

re:

"I then pressed Control-Shift-Enter and retyped the array formula and that didn't work."Why would you press Ctrl-Shift-Enter before typing the formula? That needs to be after the formula has been typed in. That is what tells Excel that it is an array formula.

re:

"I then retyped the array formula and then pressed Control-Shift-Enter and that didn't work."

What does "that didn't work" mean?re:

"What am I doing wrong?"We can't tell you what you are doing wrong until you tell us something more than it "didn't work"

message edited by DerbyDad03

DerbyDad03, Thank you for your response. The problem was caused by my entering "w" instead of "W" in the formula below:

=SUM(IF(ISNUMBER(FIND("W",U3:BE3)),VALUE(RIGHT(U3:BE3,LEN(U3:BE3)-2)),0))

Can the formula be rewritten so that it accepts either "w" or "W"?

Thanks again,

Brian

Try SEARCH instead of FIND. FIND is case sensitive, SEARCH is not. SEARCH also allows the use of certain wildcards.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll

Do you think Intel's new hybrid chips will better compete with Apple/ARM?

Yes (14) | ||

No (14) | ||

I don't know (15) |

Discuss in The Lounge

Poll History