close

I would like to sum a column with some #N/A in it.
I tried using sumif with lt;gt; quot;#N/Aquot; with no luck.
What is the criteria for not equal in this function?
Do I have to treat quot;#N/Aquot; in a special way?

=SUMIF(J:J,quot;lt;gt;#N/Aquot;,J:J)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Micahquot; gt; wrote in message
...
gt; I would like to sum a column with some #N/A in it.
gt; I tried using sumif with lt;gt; quot;#N/Aquot; with no luck.
gt; What is the criteria for not equal in this function?
gt; Do I have to treat quot;#N/Aquot; in a special way?

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

    software

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

    E-mail轉寄