Search : in
By :

Using countif to compare data in two columns

Last answer on May 1, 2009 9:28:11 pm BST dmdhca, on Dec 31, 2008 12:33:17 pm GMT 
 Report this message to moderators

Hello,

I would like to count the number of items in range a3:a6 that is greater than the items in c3:c6 example

column A column B

10 22
45 12
100 61
65 85
88 98

result


2

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Using countif to compare data in two columns » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
Download K Database Magic ShowK Database Magic is an application of SQL databases totally free. It allows you to manage, merge, compare data and more. The comparison is based on data fields specified by user. Advantages: it allows the execution of multiple SQL queries, editing...
Download ConsoXL ShowTo switch to several Excel spreadsheets when comparing data, for instance, may be tiring and cause errors. The solution is to group them into a single spreadsheet and to accomplish that you need ConsoXL. ConsoXL is an add-in for Microsoft Excel...
Download SQL Studio Data Compare Show
Data transmission - Digital data transmission ShowIntroduction to digital transmission Digital transmission is the sending of information over a physical communications media in the form of digital signals. Analogue signals must therefore be digitised first before being transmitted. However, as...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Ask your question Reply

1

Zera, on May 1, 2009 9:03:59 pm BST
  • +1

You can use array formula. When you enter a formula you press ctrl+shift+enter. So you should enter in the cell where you want your result to be displayed:
=sum(if(a2:a6>c2:c6,1,0)) and then press ctrl+shift+enter.

   
Reply to Zera

2

 Tony, on May 1, 2009 9:28:11 pm BST
  • +1

Okay, this works if you like:
column A column B
10 22
45 12
100 61
65 85
88 98
{=SUM(IF(A3:A7>B3:B7,1,0))}
//IMPORTANT, make sure to press CTRL+SHIT+ENTER rather than just ENTER, this let's the sum statement add up the arry.

result = 2

   
Reply to Tony
Ask your question Reply
They need your help