Solved

Excel 2000 - Subtotal or Vlookup?

Posted on 2011-03-03
2
251 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 500 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
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!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 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