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]

I hesitate to say it, but surely SUMIF?

 

[fry]

Hi Bitmaster

Please don't hesitate, I'm old and befuddled!! It's been a while since I played with excel.
I'm still a bit unsure of the syntax though

 

[fry]

I tried...

SUMIF(G7:G240,"Inbound",K7:K240)

but it results in zero??

 

[Trevor G]

Try SUMPRODUCT like this

Excel Workbook
	E	F	G	H	I	J
1	People	Values			People	Totals
2	John	23			John	138
3	Sarah	45			Sarah	270
4	Jack	56			Jack	336
5	John	23
6	Sarah	45
7	Jack	56
8	John	23
9	Sarah	45
10	Jack	56
11	John	23
12	Sarah	45
13	Jack	56
14	John	23
15	Sarah	45
16	Jack	56
17	John	23
18	Sarah	45
19	Jack	56
Sheet3

 

[baitmaster]

To work out the syntax, start typing "=SUMIF(" in the formula bar, but before hitting ENTER, hit the fx button just to the left of the formula bar, this brings up the information you need

In your case, try:
=SUMIF(H7:H240,"inbound",K7:K240)+SUMIF(H7:H240,"outbound",K7:K240)

 

[fry]

SUMIF(G7:G240,Inbound,K7:K240) is also zero and SUMIF(G7:M240,"Inbound",K7:K240) produces a sum of something, but not what I want???

 

[Titian]

Maybe this:-

SUMIF(G7:G240,"=Inbound",K7:K240)

 

[fry]

Ooops!!

Told you I was befuddled. Not sure why I used column G when it is clearly column H and I even asked that in my original question????

Time for one of my tablets!!

It does now work, so thank you very much baitmaster and I owe you a beer!!

 

[fry]

In fact thanks to all 3 for a lightning fast response!!