Quote Originally Posted by jjj
Thanks for that, but it doesn't work. I get an error. :-(

Any other ways of summing a range, based on a lookup?

Thanks
Hi,

When you used Carim's formula, if it doesn't work for you then you should paste back what you used and the row of data that you are looking for, and the type of error received, rather than just say 'it doesn't work' and leave the helpers here wondering what could be wrong.

If the table covers column B & C, and your two Lookup values ae in A1 and A2 then

=SUM(INDIRECT("C"&MATCH(A1,B$1:B$16,0)&":C"&MATCH(A2,B$1:B$16,0)))

should do the trick for you, but it needs to be column specific and cannot use 'Table' type named ranges.

hth
---