Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif cell greater than average
I want to be able to count how many cells hold numbers which are greater than
the average of the cells. I have a cell which shows the average and want to be able to refer to that cell in the criteria for the COUNTIF function. For example, if the cells to be counted are in A1:A10 and the average of those is in A11 I have tried COUNTIF(A1:A10,€ťA11€ť but it doesnt work! I am using 2003 |
#2
|
|||
|
|||
You almost got it.
Try this: =COUNTIF(A1:A10,""&A11) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mary Ann" wrote in message ... I want to be able to count how many cells hold numbers which are greater than the average of the cells. I have a cell which shows the average and want to be able to refer to that cell in the criteria for the COUNTIF function. For example, if the cells to be counted are in A1:A10 and the average of those is in A11 I have tried COUNTIF(A1:A10,€ťA11€ť but it doesnt work! I am using 2003 |
#3
|
|||
|
|||
Mary Ann-
Try this: =COUNTIF(A1:A0,""&A11) "Mary Ann" wrote: I want to be able to count how many cells hold numbers which are greater than the average of the cells. I have a cell which shows the average and want to be able to refer to that cell in the criteria for the COUNTIF function. For example, if the cells to be counted are in A1:A10 and the average of those is in A11 I have tried COUNTIF(A1:A10,€ťA11€ť but it doesnt work! I am using 2003 |
#4
|
|||
|
|||
Sorry, should have been:
=COUNTIF(A1:A10,""&A11) "Brian Synowiec" wrote: Mary Ann- Try this: =COUNTIF(A1:A0,""&A11) "Mary Ann" wrote: I want to be able to count how many cells hold numbers which are greater than the average of the cells. I have a cell which shows the average and want to be able to refer to that cell in the criteria for the COUNTIF function. For example, if the cells to be counted are in A1:A10 and the average of those is in A11 I have tried COUNTIF(A1:A10,€ťA11€ť but it doesnt work! I am using 2003 |
#5
|
|||
|
|||
Thanks to you both. Presumably I can use the & to connect the operator to a
full function as well as just a cell reference. E.g. =Countif(A1:A10,€ť€ť&AVERAGE(A1:A10)) "RagDyer" wrote: You almost got it. Try this: =COUNTIF(A1:A10,""&A11) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mary Ann" wrote in message ... I want to be able to count how many cells hold numbers which are greater than the average of the cells. I have a cell which shows the average and want to be able to refer to that cell in the criteria for the COUNTIF function. For example, if the cells to be counted are in A1:A10 and the average of those is in A11 I have tried COUNTIF(A1:A10,€ťA11€ť but it doesnt work! I am using 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
how do I get AVERAGE to ingore a zero value cell | Excel Worksheet Functions | |||
how do I get AVERAGE to ingore a zero value cell | Excel Worksheet Functions | |||
COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions |