office functions and formulas

[Dee]

The function I would like to create will recognize text
within a column then take the corresponding cell in the
row and add all of them together to get a total. HELP

 

[Julian Milano]

I didn't know notepad.exe had columns?