Hi
hope someone can point me in the right direction here. I have gleaned over the posts and may have missed the answer so here goes...
I have a number of worksheets with different bits of data on them but all have a common reference number and always in column A
I am trying to sum a row (say from BN:DF) based on a match and index formula.
these are my attempts.
hope someone can point me in the right direction here. I have gleaned over the posts and may have missed the answer so here goes...
I have a number of worksheets with different bits of data on them but all have a common reference number and always in column A
I am trying to sum a row (say from BN:DF) based on a match and index formula.
these are my attempts.
- =SUM(INDEX(Sales!BN:DF,MATCH(Sheet1!A2,Sales!A:A,0)))
- =SUM(Sales!(match(A2,Sales!A:A,0)BNmatch(A2,Sales!A:A,0))))