View original (French)

Counting formulas for number of rows with checks in 2 columns

Cuci -  
 Anonymous user -
Hello,

Here is my problem.

I have a table where I listed 250 people and there are several columns.

I would like to count the number of people who have a tick in column E and in column F.

I know how to count the people who have a tick in one column using =COUNTIF(range;criteria), but I can't figure out how to combine two functions to count the number of people who have a tick in both column E and column F.

I hope I made myself clear and that you can help me.

Thank you

Configuration: Windows XP / Firefox 3.6.18

2 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    If your version has the COUNTIFS function, you can count with multiple criteria

    Otherwise, you need to use SUMPRODUCT like this

    =SUMPRODUCT((range1="X")*(range2="X"))

    Best regards
    0
  2. Anonymous user
     
    I'm not the best at Excel, but you can perform this calculation in two steps:

    - In one column (for example, column G), you check each row to see if the condition is met for columns E and F: =(IF($E2="X",$F2="X")) it will write true or false in full text.
    - Then you count all the cells where it says true: for example, in column G
    =COUNTIF(G2:G252,"true").

    This can help you while waiting for a better answer.
    0