LinkBack URL
About LinkBacks
Using your supplied data, this works
Formula:
=SUM(OFFSET(A1,1,MATCH(E1,A1:C1,0)-1,100,1))
Using your supplied data, this works
Formula:=SUM(OFFSET(A1,1,MATCH(E1,A1:C1,0)-1,100,1))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks