Solved

# Formula to return Month totals

Posted on 2011-03-23
262 Views
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
Question by:vegas86
• 2

LVL 12

Accepted Solution

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

ID: 35204564
Thank you so much Tils, you are a gem!!
0

LVL 12

Expert Comment

ID: 35204567
:)
0

## Featured Post

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 …