x
Solved

# Formula to return Month totals

Posted on 2011-03-23
Medium Priority
277 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 2000 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

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.