Vlookup summing

[milewski]

is it possible using vlookup or maybe another function to sum up items with the same look up value? I am trying to sum up numbers from multiple tabs for a given date and sometimes a date might appear 5 times in a tab, but vlookup seems to only grab the last one.

example i have 5 numbers with a vlookup of X i want to be able find all X for that tab sum and move to the next tab and do the same and then get a final sum for all numbers with look up value X

 

[milewski]

this kinda seems like what im asking for, but i want it to be able to sum up the numbers not just show each one separate

http://office.microsoft.com/en-us/e...ultiple-corresponding-values-HA001226038.aspx

 

[AlphaFrog]

If you only have a few tabs to SUM from, you could use multiple SUMIF functions e.g.

=SUMIF(Sheet1!A:A, X, Sheet1!B:B) + SUMIF(Sheet2!A:A, X, Sheet2!B:B) + SUMIF(Sheet3!A:A, X, Sheet3!B:B)

This will sum the values in column B where column A equals X. It will sum all those values from Sheet1+Sheet2+Sheet3

If you have a lot of sheets to sum from, you might have to incorporate what is called a 3D SUMIF which is more involved.