close

i'm trying to do a sum of ( 5 diff Cells)and then / by number of cells that
contain a number greater than zero. Any suggestions.

=SUM(A1:A5)/COUNTIF(A1:A5,quot;gt;0quot;)

Vaya con Dios,
Chuck, CABGx3quot;Henryquot; gt; wrote in message
...
gt; i'm trying to do a sum of ( 5 diff Cells)and then / by number of cells
that
gt; contain a number greater than zero. Any suggestions.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄