?
Solved

Excel 2000 - Subtotal or Vlookup?

Posted on 2011-03-03
2
Medium Priority
?
259 Views
Last Modified: 2012-05-11
Dear Experts,

Can you please have a look that attached file, to Sheet1 B2 and B3 cells I am searching some formula, which would be able to do a kind of subtotal from Sheet2 data.

So writing the formulas in words
cell B2 = sum of Qty-ies from Sheet2 where Car1 is on Sheet2 in column A
cell B3 = sum of Qty-ies from Sheet2 where Car2 is on Sheet2 in column A

Could you please advise which formula can be proper to this, maybe VLOOKUP or SUBTOTAL?

thanks,
SumCategories.xls
0
Comment
Question by:csehz
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 35027361
Try SUMIF, in B2 copied to B3

=SUMIF(Sheet2!A:A,A2,Sheet2!B:B)

regards, barry
0
 
LVL 1

Author Closing Comment

by:csehz
ID: 35027393
Barry thanks it is perfect for me
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question