Hi. Can anyone tell me why my formula isn't working? I'm trying to sum multiple columns with the same header but its only summing the first column.
=SUM(INDEX(O12:U12,1,MATCH($O$4,$O$4:$U$4,0)))
O4 is the highlighted column header i want to match.
As you can see from the result. I'm only getting 0.5 and I want to see the value of 1.
Can't think why its not including the multiple columns.
Example.JPG
Bookmarks