Array formula
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
|