• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

looking up data in table and sum

Y

ysherriff

Member
i am learning some advanced excel lookup functions so i can begin doing dashboard analysis . i have a table and i need to sum up a category in that table. For intance i want to sum up all the share for USA region for FY 2012


for instance here is a summary table structure is setup as

[pre]
Code: 
REGION  COUNTRY       CORPORATION  FY 2011 -USD   FY 2011 -SHARE  FY 2012 -USD
USA	USA RETAIL	MSFt         11             13                  20
Latam	Brazil Retail	Pfizer       0             33                   14
USA	USA RETAIL	Pfizer       8             9                    10
Eurmea	France RETAIL	Bell         9             10                   100
[/pre]
Thanks for your help. also, i am in the market as a student. is chandoo still has his class.
 
Fastest way would be to create a PivotTable. Would easily let you put Region in the Row Field area and the FY data in the Data_Field area. Add in Country or Corporation to drill down even further if desired.

If formula, check out the SUMIF and SUMIFS functions. Something like:

=SUMIF(A:A,"USA",F:F)

Would give all the data from FY-2012 for region USA.
 
You must log in or register to reply here.
Back
Top