Search : in
By :

Count with conditions

Last answer on Apr 21, 2009 11:28:35 am BST Abby, on Nov 19, 2008 3:37:02 pm GMT 
 Report this message to moderators

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)

Configuration: Windows XP
Firefox 3.0.3

Best answers for « Count with conditions » in :
Excel to count with condition Show
Spreadsheets - Conditional expressions Show What is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
General Terms and Conditions of Use Show All Rights Reserved - 2009 - Communitic International Object These General Terms and Conditions are meant to define the ways in which the services of the website en.kioskea.net, hereafter "The Service," are made available, as well as the...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Conditional Hyphenation HTML ShowConditional Hyphenation HTML If you need to have a more precise presentation of your text (justified) in your webpage, you can use the hyphens: You can put it in words to indicate to browsers that they can, if necessary, cut these words...
Copy rows based on a condition ShowCopy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Download Count Days Show
Download Rapid TIFF Page Count Show
Download Rapid PDF Count ShowRapid PDF allows you to know the number of pages in your PDF document and to generate reports with some clicks. This program has been designed to count the words and number of pages, to measure the file size, to load or add lists, etc…It has...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
High-Availability ShowIntroduction to Reliability No matter what service is being performed by a computer system, users must have confidence in how the system operates in order to be able to use it under good conditions. The term "reliability" characterises how...
Terms of Use for kioskea.net ShowPreface These terms of use have been written in order to inform users of the site http://en.kioskea.net/ of its conditions of use, in particular for using of communications services (such as the bulletin board) which let users the world over,...
Ask your question Reply

1

 Kabir, on Apr 21, 2009 11:28:35 am BST
  • +5

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

   
Reply to Kabir
Ask your question Reply
They need your help