Vlookup question

[DSLA]

I have a Vlookup on my excel sheet:
Vlookup(A14;DATA1!D1:O500;8;false)

It collect data from another excel sheet (DATA1), with a certain cell information (Cell A14).

Only problem is that there is more than one of the same information on the data sheet.

Here is what i would like to get done:
- I would like to have the Vlookup add (count) the information from the DATA1 sheet.

For example there is two of the same cell information, and the values are 1 and 30, i want the result to be 31. Because now the situation is that it only collect the information from either the 1 or the 30, bot both.

Please ask if there was something missing on the question, my english isn't so good

 

[DSLA]

Ok, can you give me the email address?

 

[patrickmuldoon99]

pureorangejuiceman@hotmail.com

 

[DSLA]

You've got mail

 

[patrickmuldoon99]

OK, sorted now


The merged cells in Data1 were causing you problems when trying to assign D1:D153 as the lookup range for SUMIF.

I unmerged where it says "Total" on that sheet, and entered the formula. It returns 40 for the example you provided, which is correct.

I have sent the revised file back to your e-mail address, though I think you are going to have to put semi colons into the formula for it to work on your system

Hope this has been of help to you my friend

Patrick

 

[DSLA]

Ok, i got it working. Thank you so much for your help.