• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Excel 2000 - Subtotal or Vlookup?

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
csehz
Asked:
csehz
1 Solution
 
barry houdiniCommented:
Try SUMIF, in B2 copied to B3

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

regards, barry
0
 
csehzIT consultantAuthor Commented:
Barry thanks it is perfect for me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now