Array formula

J

JP

I am using an array funtion to sum a numbers followed by a letter. Example
3H,4H, etc...,
The formula looks like this:
=SUM(IF(RIGHT(C4:AD4,1)="H",--LEFT(C4:AD4,LEN(C4:AD4)-1)))

How can I add numbers followed by two letters. Example 3CT, 4CT, etc...
What do I have to do different in the function.

Thanks
 
D

Dave Peterson

Always CT?

=SUM(IF(RIGHT(C4:AD4,2)="ct",--LEFT(C4:AD4,LEN(C4:AD4)-2)))

Notice that the =right() was changed to look at 2 characters and the len() now
had 2 subtracted from it.
 
J

JP

I figured it out. I one of the cells there was only text causing the error.
Thanks for the help.
 
Top