Count with conditions

Closed
Abby - Nov 19, 2008 at 10:37 AM
 Kabir - Apr 21, 2009 at 06:28 AM
Hello,

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)

1 response

I failed to use Countif formula using more than two criteria, Please help me.
7