Hi All..........

I am trying to make a formula that will return the SUM of the range O:R of
the row in which is found the value in column A.......ie

=SUM("O"&MATCH(A12,'All WO''s'!$B:B)&":R"&MATCH(A12,'All WO''s'!$B:B))

The below formula correctly returns text of the range of interest......
="O"&MATCH(A12,'All WO''s'!$B:B)&":R"&MATCH(A12,'All WO''s'!$B:B))

but when I try to get the SUM of that range, all I get is #VALUE!


Any help would be appreciated........
Vaya con Dios,
Chuck, CABGx3