Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
4.5
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? |