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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
=COUNTIF(B1:B3,"="&B10)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gitano" wrote in message ... 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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
=COUNTIF(B1:B3,"="&B10)
"Gitano" wrote: 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!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
... as stated 4 hours earlier
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joel" wrote in message ... =COUNTIF(B1:B3,"="&B10) "Gitano" wrote: 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!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
Must have gotten hung up somewhere Bob. In my reader, Joel's was posted 33
minutes before your original. Just for information. -- Regards, Tom Ogilvy "Bob Phillips" wrote: ... as stated 4 hours earlier -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joel" wrote in message ... =COUNTIF(B1:B3,"="&B10) "Gitano" wrote: 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!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to use a countif but looking a cell value
Thanks Tom. In my reader mine is time-stamped 8:23, Joel's is 12:28. I do
think his appeared some time later. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tom Ogilvy" wrote in message ... Must have gotten hung up somewhere Bob. In my reader, Joel's was posted 33 minutes before your original. Just for information. -- Regards, Tom Ogilvy "Bob Phillips" wrote: ... as stated 4 hours earlier -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joel" wrote in message ... =COUNTIF(B1:B3,"="&B10) "Gitano" wrote: 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!! |
Reply |
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 |