muck Posted February 13, 2008 Share Posted February 13, 2008 I should know this, but I can't remember it... I have a table 48 rows long and 8 columns wide. The info in the first column is sorted alphabetically. There are 20 different items making up this 48 row field; some show up once, and some show up several times. I'm trying to sum the numbers in the 8th column for all observations of "xyz" for each of the five obervations of "xyz" in the first column. Right now, this is where I'm at: =VLOOKUP(F625,F16:M63,8) Suggestions? Quote Link to comment Share on other sites More sharing options...
Big Country Posted February 13, 2008 Share Posted February 13, 2008 (edited) Use the sumif function, if I understand your question correctly. Sum valus is the 8th column. Criteria is 1st column equals "xyz" ETA: The other option, if you wish to do this for all unique values in the first column, and it is sorted by the first column is to use the built in subtotals feature. Edited February 13, 2008 by Big Country Quote Link to comment Share on other sites More sharing options...
Easy n Dirty Posted February 13, 2008 Share Posted February 13, 2008 ETA: The other option, if you wish to do this for all unique values in the first column, and it is sorted by the first column is to use the built in subtotals feature. That was my first thought. Quote Link to comment Share on other sites More sharing options...
muck Posted February 13, 2008 Author Share Posted February 13, 2008 never used 'em before Quote Link to comment Share on other sites More sharing options...
Big Country Posted February 13, 2008 Share Posted February 13, 2008 Did either work for what you were trying to accomplish? Also, a Pivot Table would accomplish what you are looking to do. Quote Link to comment Share on other sites More sharing options...
Easy n Dirty Posted February 13, 2008 Share Posted February 13, 2008 never used 'em before Sort the data by column A. Than go to Data/Subtotals and ask to add subtotals to the columns you want totaled, using the Sum function, for every change in column A. Quote Link to comment Share on other sites More sharing options...
Chief Dick Posted February 14, 2008 Share Posted February 14, 2008 Did the earth just stop rotating? Quote Link to comment Share on other sites More sharing options...
Brentastic Posted February 14, 2008 Share Posted February 14, 2008 I don't think you can do Vlookup on one table - you need to have 2 separate data sets (if I understand your question correctly you only have one data set). Have you tried to create a pivot table and customize the data you want to sort into it? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.