Counting formulas for number of rows with checks in 2 columns
Cuci
-
Anonymous user -
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
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 réponses
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
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
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.
- 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.