Hi Bart,
This is indeed not very clear from HELP.
But this works:
=AVERAGEIF(B29:B48,">"&B25,B4:B23)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi Niek,
|
| It's a range of numbers and this range also contains blank cells:
|
| AVERAGEIF(B29:B48,">B25",B4:B23)
|
| I tried to fill the blanks with numbers but this doesn't make a difference.
| I also tried to remove the quotes, doesn't help either. When I change the
| formula to this:
|
| AVERAGEIF(B29:B48,">282",B4:B23)
|
| It does work. So the problem lies in the criteria: when I use a cell
| reference, it fails.
|
| Hope you can help.
|
| Cheers,
| Bart
|
| "Niek Otten" wrote:
|
| > Hi Bart,
| >
| > What is your formula? What are the input values?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |I really love the new AverageIF function in Excel 2007, however, it doesn't
| > | work for me
.
| > |
| > | When I use a cell reference as criteria, I get a div/0 error. If I change
| > | the cell reference by the value that is in that cell, the function works.
| > |
| > | I really hope anyone has a solution for this problem.
| > |
| > | Thanks!
| > |
| > | Bart
| >
| >
| >
