Agg Formula for Excel?

[Baron]

Any of you Excel experts have or know how to write a formula that will Average a 4 Target Agg in one cell unless DQ is entered into one of the target cells instead of a number (group size). The result giving a DQ for the Average.
Example:
1.000”, 1.000”, 1.000”, 1.000” = 1.000”
1.000”, DQ, 1.000”, 1.000”= DQ
Baron

 

[Turbulent Turtle]

If using cells a1, b1, c1 and d1 to store the 4 values and the cells have either a number or the letters DQ, then enter this formula in cell e1:

=IF(A1<>"DQ",IF(B1 <>"DQ",IF(C1<>"DQ",IF(D1<>"DQ", AVERAGE(A11),"DQ"),"DQ"),"DQ"),"DQ")


That's one quick way of doing this.

 

[Baron]

Thanks Bayou! Worked like a charm!
Baron

 

[Turbulent Turtle]

Happy to help.