I'm currently working on a set of observation data and am trying to create a count formula based on multiple conditions. eg.
Mon Mon Mon
Booked 0 1 1
Used 0 0 1
I have the frequency of observations in columns and am recording 1 = yes and 0 = no in rows. I want to count out of all of my observations (A:AY) how many times booked = used. I also want to know when the two rows aren't equal, is Booked > Used or is Booked < Used.
I've tried various countif functions but think I'm missing something if I need to compare rows. Any help would be marvelous :o)
