Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Array/CSE Formulae no longer work.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="InaPickle, post: 6805188"] Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Dear All, I am using an array formula that worked in excel 2003. =AVERAGE(IF(AGM!$D$3:$D$240=Paths!B2,AGM!$E$3:$E$240)) It should work, but i get a #DIV/0! message in the cell after pressing CSE. There are no blank values in the ranges. Does anyone know how I can get this to work? Thank you. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Array/CSE Formulae no longer work.
Top
