Solved

Excel 2000 - Subtotal or Vlookup?

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
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…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now