| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif when the criteria is a formula
On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10"). Can anyone help? Nestor |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif when the criteria is a formula
=COUNTIF(A1:A10,"<" & B10)
for example, from A1 thru C20: 29 29 24 23 13 24 28 8 13 25 21.6 3 16 20.3 4 15 18.9 5 5 17 6 23 17 6 28 18.5 5 14 17.5 6 7 15.4 6 30 17.6 6 21 18.4 5 20 17.9 5 -- Gary''s Student - gsnu200838 "Nestor" wrote: On col A1toA100 have number,from col B10 have the averages of last 10 numbers AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10"). Can anyone help? Nestor |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif when the criteria is a formula
=COUNTIF(A1:A10,""&B10)
Regards, Stefi €˛Nestor€¯ ezt Ć*rta: On col A1toA100 have number,from col B10 have the averages of last 10 numbers AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10"). Can anyone help? Nestor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| 2 criteria for a COUNTIF formula? | New Users to Excel | |||
| Countif Formula with changing criteria | Excel Discussion (Misc queries) | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
![Nestor[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
