vegas86
asked on
Formula to return Month totals
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:)
ASKER