How do I create a formula using data from another page?
 

I have a 2 page worksheet....Part A and Part B. I would like to create a
formula that will always automatically bring the totals from various columns
of Part B onto various cells in Part A.

HELP!

One way:

In sheet Part A:

=SUM('Part B'!A1:A100)

In article ,
"Mimi" wrote:

I have a 2 page worksheet....Part A and Part B. I would like to create a
formula that will always automatically bring the totals from various columns
of Part B onto various cells in Part A.

Thank you...it worked! You're a genius!

"Mimi" wrote:

I have a 2 page worksheet....Part A and Part B. I would like to create a
formula that will always automatically bring the totals from various columns
of Part B onto various cells in Part A.

HELP!