Working on possible countif statement but got confused when i added third variable.
1) on sheet3 I want to look on sheet2 for Column A:A for "DOG"
2) then look in column B:B for "A"
3) I then look in Sheet3 "B2" which corresponds to Sheet2 C1to I1
In my example i used 2023 as this number changes every year so i was trying to do a Dropdown with a Vlookup or just a count if but since i will change the range on sheet3 B2 i was going in loop with no success. Any help would be a bonus.