Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to check first 5 characters of a cell & then sum
Hi,
I'm looking for a way to check the first 5 characters of a cell for a certain value and if it equals that value to sum the value of another cell e.g. Column A, B, ght991xyz, 10 ght887fht, 100 ght991xyz, 50 ght887fht, 7 So in the example above I'd want to check all rows where column A starts with ght991 and then sums the value of column B. So the result of the above would be 60 (50+10).. Not that column A will always contain digits after the first five, but only the first 5 will match. Any help would be greatly appreciated. Best Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
Characters in cell | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Transfer specific characters from cell to another cell. | New Users to Excel | |||
Check for Alpha characters | Excel Discussion (Misc queries) |