Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
Hi! I got 66 in Cell A1, 67 Cell B1 and 64 in Cell C1.
What formula should be if any of these number less than 65, there is 0 display. Now, there is two over 65 so it should display 2!
Example: 1) 68, 64 , 66
= 2
2) 70, 50, 51
= 13) 70, 90, 100
= 3Thanks
Use the Countif function. For your example, if you wanted the result in d1, then d1 = countif(a1:c1, ">65")
0 
But still not working because of this!
In cell
A1 = 62, B1 =12, C1=74, D1=66,E1 =18,F1=84,I just need to count C1 and and F1!
When these two cells reach 65 or more than appear 2 but if two of them less than 65 then 0!
0
Maybe a typo, but c1=74, d1=66, f1=84 so you're answer should be 3. Change c1 and f1 to less than 65, you still get 1.
Unless you only want to check c1 and f1.
0
no, the answer should be two because only country C1 and F1.
I am doing marksheet! For A1=20%, B1=80%, C1=100%. D1=20%, E1=80%, F1=100%.
I only need to count the 100% one! If less than 65 then it will produce the result!
0
I'm not following you. The term "marksheet" doesn't mean anything to me.
Are there numbers other than a1:f1 that need to be considered? First you say >65, now you say only 100%. I'm not sure exactly what your criteria for being counted is. If you could clarify, maybe I can help. Sorry.
0
ok! At the 100% column, if formula should applied is like this!
If the 100% column is less than 64, then there is not one but if over or equal to then appear 1~
The formula which you show me was A1:F1 which means it will count from A1 to F1
I want Just C3 and F3! Now all!
Thanks
0
I think I get it.
A1=20%, B1=80%, C1=100%. D1=20%, E1=80%,
F1=100%
A3 = 62, B3 =12, C3=74, D3=66,E3 =18,F3=84,
You need to check row 1 to see if it's 100% then
check row 3 to see if it's over 64. Hopefully, you
don't have several rows, because we need to place
two functions, one to check the two values and
another to add them up. If you have more than one
row, just insert a blank row in between and then hide
it. This will work.in a4 type =IF(a3>64,IF(a1=1,1,0),0) this will place a
1 if both conditions are met. Fill this formula to
column F. Then if G3 type =sum(a4:f4) adding up the
returned 1's. In the example 2. If you need to print
this or have more than one row you can copy and
paste, then hide the row with the if statements.Hope this helped!
0
I think you got my point but your formula is not working! Check your mail! I send you a sample of my marksheet and the formula should only applied at the results column. Count only the 100% column.
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
