Hello all,
I am using the following formula to try and sum the total value in column G each time the corresponding entry in column E matches. =SUM(INDEX('Cost estimate'!G1:G909,MATCH('Crew usage & L&E report'!A3,'Cost estimate'!E1:E909,0))) However, this is only returning one instance of the match rather than a total. Any help is greatly appreciated!!
Thanks,
Mark
Bookmarks