Hi!
Here is my problem =
I have a huge worksheet, with many columns ands hundreds of rows.
Some of the columns are basically the answers to a survey, meaning that for each row, the value is a nomber between 1 and 5.
In order to do a few charts and tabs with them, i need to count the number of 4, the number of 5 and so on.
For now, no problem, I used a COUNTIF and it worked well.
The thing is that i also want to be able to count them in only parts of the rows. for instance, number of 4 in july, or number of 3 for this region..
Could you help me with this? I tried
=COUNT(IF(A2:A9=2;IF(B2:B9=1;1;0);0))
its just an exemple where the region number would be 2 and the number im looking for is 1, but its not working.
I thought of subtotals, but i cant find the way to do a countif inside..
could you help me please? Thanks for your ideas!
Here is my problem =
I have a huge worksheet, with many columns ands hundreds of rows.
Some of the columns are basically the answers to a survey, meaning that for each row, the value is a nomber between 1 and 5.
In order to do a few charts and tabs with them, i need to count the number of 4, the number of 5 and so on.
For now, no problem, I used a COUNTIF and it worked well.
The thing is that i also want to be able to count them in only parts of the rows. for instance, number of 4 in july, or number of 3 for this region..
Could you help me with this? I tried
=COUNT(IF(A2:A9=2;IF(B2:B9=1;1;0);0))
its just an exemple where the region number would be 2 and the number im looking for is 1, but its not working.
I thought of subtotals, but i cant find the way to do a countif inside..
could you help me please? Thanks for your ideas!