AverageIF with cell refenrence as criteria is not working

[Guest]

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

 

[Niek Otten]

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

 

[Guest]

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]

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
| >
| >
| >

 

[Bart Geerling]

Thanks Niek.

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

Thanks!
Bart