Using Multiple Worksheets. Worksheet one is where the data is entered
Worksheet too using index_match to pull data after matching name and date. How do I add data together from data that was entered multiple times with same name and date
Formula used to find and pull data
=IFERROR(INDEX('Audit list'!F$1:F$500,MATCH('2ND_3RD'!$C4&'2ND_3RD'!I$1,'Audit list'!$L:$L,0)),"")
Audit List is worksheet 1 - column F is where the data is entered I want to add
in Match, 2nd_3rd and where I am adding a name and date together and matching it to column L in the AUDIT LIST work book.
I am able to pull back the first cell it finds, but not sum any other cells with same name and date
Worksheet too using index_match to pull data after matching name and date. How do I add data together from data that was entered multiple times with same name and date
Formula used to find and pull data
=IFERROR(INDEX('Audit list'!F$1:F$500,MATCH('2ND_3RD'!$C4&'2ND_3RD'!I$1,'Audit list'!$L:$L,0)),"")
Audit List is worksheet 1 - column F is where the data is entered I want to add
in Match, 2nd_3rd and where I am adding a name and date together and matching it to column L in the AUDIT LIST work book.
I am able to pull back the first cell it finds, but not sum any other cells with same name and date