Learning Goal: I’m working on a excel spreadsheet and need guidance to help me learn.
I would like to have a sheet for my farm, including cage numbers from 1 to anything I could add, and for each cage, I would like to have a bird count from 1 to 4, and for each cage, I would like to have an age, and each day the age adds one day to the bird’s age, and I would like to have the number of birds I have and the ages for them as a total count. For example, if I have 20 birds whose ages are 20 days, 22 birds are 24 days old, and 60 birds are 40 days old, i want it to say 20 birds are 20 days old and 22 birds are 24 days old and so on and i want it to say for each age group in which cages they are in as for example 20 days old are in cages 2, 6 ,9 ,12 in order and the 24 days old are in cages 1,3,5 and easily edited if i removed the bird from the cage i want it to easily edit the number of bird in that cage and not only for the ages i mention above for each age from 1 to 30 i want to have a count and cage number for it