Search : in
By :

Count number of cells matching to criteria

Last answer on Jan 16, 2009 8:56:37 pm GMT Rusty, on Jan 16, 2009 7:17:01 pm GMT 
 Report this message to moderators

Hello,

I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting to find out how to auto count two criteria such as... if the first column is 1 and the second column is A then count. i.e for this example the answer would be..3.

Help?
Thanks

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Count number of cells matching to criteria » in :
How to count number of words in MS Words sheet! Show How to count number of words in MS Words sheet! It is quite simple to count the number of words in a Microsoft word sheet. This tip might be very useful for example, if you wish to make a presentation on Microsoft word for an approximate...
Partial Cell Match of Company Names in Excel Show
Text String count within a Cell (Solved) Show
Counting the number of words in a document (Word or OpenOffice) ShowCounting the number of words in a document (Word or OpenOffice.org) Microsoft Word OpenOffice.org It is sometimes useful to count the number of words or characters in a document. The two major office suites can do it very...
Unlimited Conditional Formatting ShowUnlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
[C language]Checking whether an integer is a prime number Show[C language]Checking whether an integer is a prime number Definition of a prime number Algorithm 1: dividers between 2 and N-1 will be tested Algorithm 2: Even dividers will not be tested, research is limited to odd dividers Algorithm 3:...
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Don�t panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
Download Random Number Generator Pro ShowRandom Number Generator Pro is a tool that generates a list of random numbers based on customizable criteria. You can choose the minimum and maximum limits and incrementing numbers. Limits can be positive or negative values. Advantage The...
Download A-PDF Number ShowDescription The application is designed by A-PDF.com. Simple and easy to use, the application is completely FREE! A-PDF Number is tool that allows you to add or create the page numbers in PDF files. The application allows you to create documents...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Computer graphics Show
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...
Ask your question Reply

1

 aquarelle, on Jan 16, 2009 8:56:37 pm GMT
  • +6

Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle
Ask your question Reply
They need your help