a macro
Sub averagearray()
For Each c In Array(1, 2, 3, 10, 23, 34)
If Cells(c, "a") 4.5 Then
ms = ms + Cells(c, "a")
cc = cc + 1
End If
Next c
MsgBox ms
MsgBox cc
MsgBox ms / cc
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mellybean" wrote in message
...
Hello I have a worksheet that I need to find the value of cells greater
than
4.5 i have tried =AVERAGE(IF(A1:A30=4.5,A1:A30)) and it works but i only
need certain cells for example i only need cells A1,A2,A3,A4,A10,A23,A34
but
only if they are 4.5 what is the formula?