Division assistance anyone?

[putek]

I am trying to figure out a formula for dividing the following:
I have cells B1-B145, with the sum in cell B158.
In cell C1 I have the following function: =B1/B158, which works fine. The problem.....I don't know how to proceed down the list and have C2 show: =B2/B158.

Any help would be appreciated. It seems like it would be simple, but I am stumped.

Thanks!

[Bryan Hessey]

I am trying to figure out a formula for dividing the following:
I have cells B1-B145, with the sum in cell B158.
In cell C1 I have the following function: =B1/B158, which works fine. The problem.....I don't know how to proceed down the list and have C2 show: =B2/B158.

Any help would be appreciated. It seems like it would be simple, but I am stumped.

Thanks!

=B2/B$158

hth
---

[putek]

Thanks a million!!

[Bryan Hessey]

Thanks a million!!

np - and thanks for your response.

---