Hi
enter the following formula as array formula (with CTRL+SHIFT+ENTER) in
O27:
=AVERAGE(IF($D$1:$D$100="Assembly",$G$1:$G$100))

similar for MAX and STDEV. e.g.
=MAX(IF($D$1:$D$100="Assembly",$G$1:$G$100))
and
=STDEV(IF($D$1:$D$100="Assembly",$G$1:$G$100))

Note: all are array formulas!

--
Regards
Frank Kabel
Frankfurt, Germany


I have a deadline in two hours if anyone can help with this I would
be
extremely grateful.

Here is an attept at psuedocode:
(Column D is sorted so all same values are next to each other
vertically) this might help

For all col D
If col D = "Assembly"
select range in corresponding row in col G
and average the numbers that are in that range in col G
paste that average in col O row 27

Example:

Col D................ColG

Assembly............4
Assembly............2
Assembly............0
Assembly............3
Check.................1
Check.................6

I need to average the numbers in col G for all Assembly (I also need
to do the max and the stdev calculations for the same ranges.
The spreadsheet will change daily so the range will vary.

Please Help
Thank you very much

Morry


---
Message posted from http://www.ExcelForum.com/