close

I have a long list of numbers that ranges from 680,608.60 to 131.06.
I need to sum only those within 50,001 and 200,000.

=SUMIF(A:A,quot;gt;=50001quot;)-SUMIF(A:A,quot;gt;200000quot;)

Vaya con Dios,
Chuck, CABGx3quot;Luisquot; gt; wrote in message
news
gt; I have a long list of numbers that ranges from 680,608.60 to 131.06.
gt; I need to sum only those within 50,001 and 200,000.

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

    software

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