Posted to microsoft.public.excel.worksheet.functions

Harlan Grove[_2_] Harlan Grove[_2_] is offline

external usenet poster

Posts: 1,231

Adding or to previously provided Average If Array function

"T. Valko" wrote...
=IF(OR(Q34, Q44, Q53,Q63),
MAX(3,AVERAGE(IF(score0,score))),AVERAGE(IF(sco re0,score)))

I didn't even think of that. Since it's already an array formula we could
also do this:

=IF(OR(Q3:Q44,Q5:Q63),MAX(3,AVERAGE(IF(score0, score))),AVERAGE(IF(score0,score)))
....

Somewhat on a tangent, should this return a number when there are no
numbers at all in the range named score? If not, then maybe the
following array formula.

=IF(COUNT(score),MAX(IF(OR(Q3:Q44,Q5:Q63),3,-1E307),AVERAGE(IF
(score0,score))),"")

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
Adding if to Average If Array function	Diddy	Excel Worksheet Functions	5	December 10th 09 03:45 PM
Adding rows to the data array used in an Index function	Lanhing	Excel Discussion (Misc queries)	1	April 7th 09 07:45 PM
Adding error suppression to AVERAGE FUNCTION	plb2862	Excel Worksheet Functions	3	December 7th 06 05:16 PM
Small Array is too big for AVERAGE Function?	daven123	Excel Worksheet Functions	6	November 29th 06 02:22 PM
Can a cell refer to range name/array of data previously set?	Courreges	Excel Discussion (Misc queries)	1	June 12th 06 02:45 PM

All times are GMT +1. The time now is 06:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us