set sumrange = sheets("Tab1").Range("B3:B9")
mysum = worksheetfunction.sum(sumrange)

" wrote:

I'm wondering if I can do the following with this table...on
tab1(snippet of raw data)
colA colB
2 55
3 57
6 51
9 40
10 42

I was trying to get vlookup to to work on tab2...
colA colB
3 * this is where I want to use vlookup
9

What I need to do is sum up all values in tab1.colB from 3 through 9.
So I was thinking if I could get vlookup to return the cell number
then I can do a sum from the return value. I hope I'm making this
clear. Any help is appreciated.

-Bruce