I am trying to evaluate some information from an animal studying exercise using Google Sheets.
I'd like to know how many times the animal:
- forages then allogrooms
- sleeps then allogrooms
Also what the animal is likely to do after allogrooming. (Allogrooming is when it grooms one of its peers.)
I need to input another 9-hours of observation, so to work this out manually is not an option.
If you look at my spreadsheet you know know what I mean, but basically, I need a formula that counts how many times all the activities come before allogrooming and how many times x activities come after allogrooming.
I've highlighted the area I need some help with yellow.
The document is a copy and is editable.