Hi,
I have been using VLOOKUP to to coalate durations per month which has been fine untill there a 2 or more duration that fall in the same month. How do I get them to add together in the one cell.
Example as shown should answer 12 for 41913 but it only shows 6 using (=VLOOKUP(B14,WINDER!$E$3:$F$35,2,FALSE)
41883 6
41913 6
41913 6
Bookmarks