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

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

software

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