Solved

Formula to return Month totals

Posted on 2011-03-23
3
262 Views
Last Modified: 2012-05-11
Hello,

I am working on the attached sheet and I would like to link Sheet 1 to sheet 2.
Sheet 2 is currently broken up into species (column D) and has percentages based on each species code.
However in sheet 1 I would instead like to base the total amounts on the Kennel (column B) for each month and year.

So for example in sheet 1 cell G2 would have a total of all species of dogs within kennel K2 for January 2007 and so on.

Can someone please let me know how I would go about doing so?

EXAMPLE1.xlsx
0
Comment
Question by:vegas86
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
tilsant earned 500 total points
ID: 35204554
If your headers always remain in the same order, then you can use the below formula in G2 and then drag right and down:
=SUMPRODUCT(--($B2=Sheet2!$B$2:$B$1753),--($F2=Sheet2!$G$2:$G$1753),Sheet2!H$2:H$1753)


Tils.
Copy-of-EXAMPLE1.xlsx
0
 

Author Closing Comment

by:vegas86
ID: 35204564
Thank you so much Tils, you are a gem!!
0
 
LVL 12

Expert Comment

by:tilsant
ID: 35204567
:)
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

707 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

18 Experts available now in Live!

Get 1:1 Help Now