VlookUp to sum up more than one column or value

[gebo84]

I have a "tasks data" spreadsheet where i am capturing staff daily activities.
For example in column A is Monday, B is Tuesday and so on, with times down the rows in 15 min intervals, the staff member would then fill this out as the day progresses on tasks they have performed. I am trying to accumulate the total time taking for each task at the end of the week. So in Mondays column they may have "emails" down 2 or 3 times. the formula i have been working with is only capturing the first instance of "emails" in each column and not recognizing the other entries, i need help coming up with a formula that will look at the table and return total values for each task.

=(VLOOKUP(L4,A5:J20,{2,4,6,8,10},0))

this is the formula i am working with

L4 being the word "emails"
A5:J20 being the table of data i need to look at
2,4,6,8,10 are the column numbers i need the formula to look into to return the total sum

can anyone help?

thanks
George

 

[Marcelo Branco]

Maybe this array formula
=SUM(IF(A5:A20=L4,IF(MOD(COLUMN(B5:J20)-COLUMN(B5)+1,2)=1,B5:J20)))
confirmed with Ctrl+Shift+Enter, not just Enter

Hope this helps

M.

 

[gebo84]

Thanks Marcelo, ive got that working

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.