I am currently having =ADDRESS(MATCH(Scheduled!B5,Sunday!N12:N40,0)+11,14) search and return the address of the cell its located in...
that works all fine, however what I need now is when it finds the cell its located in, i need to be able to add up values in cells in the same row that its found in.

so if b5 = "test"
searches Sunday worksheet between N12:N40

Finds it on lets say N16

Returns $N$16

Now I need to add up values from T12:AO12

I hope this makes sense
Thanks