help with vlookup(ish) problem please?

[fry]

Hi All

Sorry about the title, I didn't know how to explain

What I'm trying to do is a bit like vlookup but instead of returning 1 value I want to add up all the values???

My array is G7:M240 so what I need to do is look down column H and wherever a value is found (in this case Inbound or Outbound) I want to take the value on that row in column K and then add it to the rest to produce a sum of inbounds or outbounds?

Could someone help?

Thanks a lot!

 

[baitmaster]

beer would be perfect, please email one to me. I use cable, so it should fit down the tube ok

 

[fry]

I'm on cable too...........I'll do my best, but based on my ability to sort out a simple equation and fail, don't hold your breath!!

Thanks again!!

 

[baitmaster]

No, its easy... see the tray that slides out of your PC, looks like a cup holder? You can insert a tube there, and pour beer straight in...

 

[fry]

So.............that's what it's for!!

Here's me been thinking it's a large cigar end cutter......albeit blunt!!

Sorted