Using COUNTIFS in VBA from from a data worksheet to a macro page

[harlesbarkly]

Hello,
I was wondering if any “excel Studs” knew how to use the countIFs function in excel using strings found in a worksheet cells. This is the last stage of a code I have been working on for a few weeks now. Here is a example so you can better understand the goal of the task.

End Chart should look like this( last column needs to be filled)
[TABLE="width: 355"]
<tbody>[TR]
[TD]Year[/TD]
[TD]animal[/TD]
[TD]Location[/TD]
[TD]# at given location[/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Cat[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Bird[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Dog[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Cat[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 1[/TD]
[TD]Bird[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Cat[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Bird[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Dog[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Cat[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 2[/TD]
[TD]Bird[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Cat[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Bird[/TD]
[TD]Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Dog[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Cat[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Year 3[/TD]
[TD]Bird[/TD]
[TD]"blank"[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And the data that is used to count the # of occurrences looks like this
[TABLE="width: 362"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Location in year[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Animal[/TD]
[TD]Year 1[/TD]
[TD]Year 2[/TD]
[TD]Year 3[/TD]
[/TR]
[TR]
[TD]Ralph[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Molly[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Eve[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Rex[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Typhoon[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Obama[/TD]
[TD]Bird[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Kitty[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Sir[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[TD]farm[/TD]
[/TR]
[TR]
[TD]Tommy[/TD]
[TD]Cat[/TD]
[TD][/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[/TR]
[TR]
[TD]Nick[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]k9[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Neko[/TD]
[TD]Cat[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]inu[/TD]
[TD]Dog[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Bucky[/TD]
[TD]Dog[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]Inru[/TD]
[TD]Bird[/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[/TR]
[TR]
[TD]enru[/TD]
[TD]Bird[/TD]
[TD][/TD]
[TD]Farm[/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]luffy[/TD]
[TD]Dog[/TD]
[TD][/TD]
[TD]Shelter[/TD]
[TD]Shelter[/TD]
[/TR]
[TR]
[TD]midori[/TD]
[TD]Bird[/TD]
[TD][/TD]
[TD][/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]oracle[/TD]
[TD]Bird[/TD]
[TD][/TD]
[TD][/TD]
[TD]Farm[/TD]
[/TR]
[TR]
[TD]banksy[/TD]
[TD]Cat[/TD]
[TD]Shelter[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Note: "Blank" means that the data cell is empty.
I hope all of your days are going well.
From,
a young padawan disciple

 

[harlesbarkly]

Hoping for help post LOL