[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2014-08-21
2
Medium Priority
?
99 Views
Last Modified: 2014-09-05
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.
0
Comment
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40278256
Hi,

pls try

=SUMPRODUCT(K5:K184,--(ROW(A5:A184)-4>=MATCH("started",A5:A184,0)),--(ROW(A5:A184)-4<=MATCH("ended",A5:A184,0)))

Regards
EE20140822.xlsx
0
 

Author Closing Comment

by:Connie Campbell-Pearson
ID: 40306385
This was great to have. I had to tweak it for some other purposes, but it really gave me the right direction. Thank you
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn the different options available in the Backstage view in Excel 2013.
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question