User Profile
PhilB2401
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Excel Vlookup + Sum multiple values in a column
I have a worksheet where weekly scores are recorded in column D. Identifying number is in Column A. On a separate worksheet, I need to look up the identifier and then return the sum of 4 scores. I have tried =SUM(VLOOKUP(A3, 'DNAv ORS scores'!D:D, {2,3,4,5}, FALSE)) but returning #N/A error. Can anyone help or provide a suggestion please?1.3KViews0likes2Comments
Recent Blog Articles
No content to show