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

[Mimi]

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!

 

[JE McGimpsey]

One way:

In sheet Part A:

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

 

[Mimi]

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