EE20140822.xlsx

<div>
This was great to have. I had to tweak it for some other purposes, but it really gave me the right direction. Thank you
</div>


This was great to have. I had to tweak it for some other purposes, but it really gave me the right direction. Thank you

<div>
<div class="content wysiwyg-content">
Column A has the word &quot;started&quot; and &quot;ended&quot; located in some cell between A5 and A184. Once I have located the word &quot;started&quot; and &quot;ended&quot; &nbsp;in column A (right now I am using the match function and have the location), I want to sum the values in column K that correspond to started and ended in column A.
</div>
</div>


Column A has the word "started" and "ended" located in some cell between A5 and A184. Once I have located the word "started" and "ended"  in column A (right now I am using the match function and have the location), I want to sum the values in column K that correspond to started and ended in column A.

find the name of the cell (not the value) in another column based on the location of a value in the first column

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.