Summing values in a string

Tweet

Summing values in a string containing textual & numerical substrings. Problem: -------- Listed in columns A & B are file names and their sizes, each of which is one of three types (KB, MB or GB). Solution: --------- Use the SUM, IF, ISNUMBER, FIND, VALUE, and LEFT functions as shown in the following Array formula: {=SUM(IF(ISNUMBER(FIND(C2,B2:B5)),VALUE(LEFT(B2:B5,FIND(C2,B2:B5)-1)),0))} Cheers! ~~SiFaR~~ http://sifar.ueuo.com