If I've understood correctly this may do what you want:-

=SUMIF(Sheet1!A1:A5,"=3",Sheet1!B1:B5)-(SUMIF(Sheet1!A1:A5,"9",Sheet1!B1:B5))

Mike

" 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