SOURCE: Should I use countif or if or what ??
Here, paste this formula in D1 then copy it down to the last row:
=SUM(IF($A$1:$A$30=A1,IF($C$1:$C$30="Yes",1,0)))
MatRex
SOURCE: FORMULA TO COMPLETE A COUNT TO A PERCENTAGE
I am not sure but I was looking at this problem and I thought the equation should be reversed as I put it below. This gives a percetage of the entrys that are of the value 1 as it seems you are looking for.
=COUNTIF(A3:A74,"1")/COUNT(A3:A74)*100
SOURCE: Countifs
The formula in both versions is the same:
=countif(range,value)
i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)
SOURCE: Cannot get COUNTIF to work!
The only thing I see wrong in your formula is a missing colon.
COUNTIF($C$2:$C$999,C2)=1
SOURCE: copy formulas
It should work if you just copy and paste it. Or select the range of your working area and right click in destination cell and choose paste special. When new window pop up, just choose Formula.
It should work usually, but by any chance you've encountered the problem regarding this. Just let me know...i'll try to help you...
P.S.: If this information was helpful, please rate this solution.
200 views
Usually answered in minutes!
×