Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
I need to count how many students have a 70% and over of a value in a cell
that A B C D Example: 1 Lisa 70 55 50 A B C D 2 Mike 44 40 70 9 Value 80 60 75 3 Rose 57 30 53 10 70% 56 43 53 (=b9*0.7) ok 11Amount Stu =count(b1:b3) give 3 that's OK 12 Amount with =countif (b1:b3, "=56) give 2 thats OK but instead of 56 i need and over 70% to look in a cell (b10) WHEN I DID IT GIVE 0. =coutif (b1:b3,"=b10") Help me!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF, criteria is cell-to-cell comparison | Excel Worksheet Functions | |||
RE COUNTIF: use < before a cell | Excel Discussion (Misc queries) | |||
countif cell pattern = | Excel Worksheet Functions | |||
Countif with cell reference | Excel Worksheet Functions | |||
COUNTIF > CELL VALUE | Excel Worksheet Functions |