close

Within a workbook in Excel, there are multiple worksheets. How do I sum up a
particular cell (say C10) in each worksheets (say worksheet 1-5) ?

=sum(Sheet1:Sheet5!C10). Beware that the sheets included in the sum are
based on the sequence of the sheets (thus, if you moved Sheet4 after Sheet5,
Sheet4 would be excluded from the sum).quot;lpsungquot; wrote:

gt; Within a workbook in Excel, there are multiple worksheets. How do I sum up a
gt; particular cell (say C10) in each worksheets (say worksheet 1-5) ?

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

    software

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

    E-mail轉寄