could someone please review this spreadsheet and let me know how I might resolve this problem. I am trying to create a formula that will add up all the instances in a range of numbers - but it is stopping the summation at the FIRST instance of the last number in the range vs. counting all the instances of the last number range.
Thanks.
=SUM(INDEX(Hours,MATCH(J3,jobnumber,0)) : (INDEX(Hours,MAX(IF(jobnumber=L3,ROW(jobnumber)-ROW($A$3)+1),0))))
Confirm Control+Shift+Enter
Change your ranges
jobnumbers an hours to cover only rows 3:500
=Sheet1!$E$3:$E$500
and
=Sheet1!$A$3:$A$500
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks