harlesbarkly
New Member
- Joined
- Aug 18, 2014
- Messages
- 4
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)
<tbody>
</tbody>
And the data that is used to count the # of occurrences looks like this
<tbody>
</tbody>
Note: "Blank" means that the data cell is empty.
I hope all of your days are going well.
From,
a young padawan disciple
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)
| Year | animal | Location | # at given location |
| Year 1 | Dog | Shelter | |
| Year 1 | Cat | Shelter | |
| Year 1 | Bird | Shelter | |
| Year 1 | Dog | Farm | |
| Year 1 | Cat | Farm | |
| Year 1 | Bird | Farm | |
| Year 1 | Dog | "blank" | |
| Year 1 | Cat | "blank" | |
| Year 1 | Bird | "blank" | |
| Year 2 | Dog | Shelter | |
| Year 2 | Cat | Shelter | |
| Year 2 | Bird | Shelter | |
| Year 2 | Dog | Farm | |
| Year 2 | Cat | Farm | |
| Year 2 | Bird | Farm | |
| Year 2 | Dog | "blank" | |
| Year 2 | Cat | "blank" | |
| Year 2 | Bird | "blank" | |
| Year 3 | Dog | Shelter | |
| Year 3 | Cat | Shelter | |
| Year 3 | Bird | Shelter | |
| Year 3 | Dog | Farm | |
| Year 3 | Cat | Farm | |
| Year 3 | Bird | Farm | |
| Year 3 | Dog | "blank" | |
| Year 3 | Cat | "blank" | |
| Year 3 | Bird | "blank" |
<tbody>
</tbody>
And the data that is used to count the # of occurrences looks like this
| Location in year | ||||
| Name | Animal | Year 1 | Year 2 | Year 3 |
| Ralph | Dog | Shelter | Farm | Farm |
| George | Dog | Shelter | Farm | |
| Molly | Cat | Shelter | Shelter | Farm |
| Eve | Dog | Shelter | Shelter | Farm |
| Rex | Cat | Shelter | Farm | Farm |
| Typhoon | Bird | Shelter | ||
| Obama | Bird | Farm | Farm | Farm |
| Kitty | Dog | Farm | Farm | Farm |
| Sir | Bird | Shelter | farm | |
| Tommy | Cat | Shelter | Shelter | |
| Nick | Cat | Shelter | Farm | Farm |
| k9 | Dog | Farm | Farm | Farm |
| Neko | Cat | Farm | Farm | Farm |
| inu | Dog | Shelter | Farm | |
| Bucky | Dog | Farm | Farm | Farm |
| Inru | Bird | Shelter | Shelter | Shelter |
| enru | Bird | Farm | Farm | |
| luffy | Dog | Shelter | Shelter | |
| midori | Bird | Farm | ||
| oracle | Bird | Farm | ||
| banksy | Cat | Shelter |
<tbody>
</tbody>
Note: "Blank" means that the data cell is empty.
I hope all of your days are going well.
From,
a young padawan disciple
