close

This probably has a simple solution, but I can't find it. I have multiple
sheets I'm working with. I want to take the sum of a column in one sheet and
post the total both at the bottom on that page as well as my main page. Thanx
for any help!

Imagine your total is in cell D20 of a sheet called quot;Dataquot; - its
formula will besomething like:

=SUM(D119)

In your quot;Summaryquot; sheet, you will need the formula:

=Data!D20

Hope this helps.

Pete

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

    software

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