Posted to microsoft.public.excel.misc

Bart Geerling Bart Geerling is offline

external usenet poster

Posts: 1

AverageIF with cell refenrence as criteria is not working

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AverageIF	coastal	Excel Discussion (Misc queries)	1	November 13th 07 11:28 PM
SUMIF/PRODUCT with multiple Criteria not working	Andi	Excel Discussion (Misc queries)	4	January 22nd 07 06:01 PM
averageif	name	Excel Worksheet Functions	1	May 4th 06 05:27 PM
averageif	rudy	Excel Discussion (Misc queries)	5	April 27th 06 11:20 PM
Sumproduct w/date criteria not working	JANA	Excel Worksheet Functions	7	April 15th 05 11:19 AM

All times are GMT +1. The time now is 12:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us