Summing a Vlookup

[jjj]

Hi,

Is there any way of summing values based on a lookup?

i.e. =sum(vlookup(a1,table,2):vlookup(a1,table,4)

This formula does not work, i want to sum the the values from cell 2 to 4, in the table, hence trying to sum '=sum(a2:a4)' from my table

Please let me know if you need more clarity around this, and many thanks.

[Carim]

Hi,

Please Login or Register  to view this content.

HTH
Carim

[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

[Bryan Hessey]

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
---