Thanks Niek.

That does it. But like you say, it isn't really clear form HELP.

Thanks!
Bart

"Niek Otten" wrote:

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

"Bart Geerling" wrote in message
...
| 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
|
| "Bart Geerling" <Bart wrote in message
| ...
| |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
|
|
|