Named Ranges in Formulas

  • Thread starter Thread starter Rich Mogy
  • Start date Start date
R

Rich Mogy

I have a worksheet with four columns -

Total Hours
Percent to total Hours
Value of Hours
Percent to total Value of Hours

The row with the total varies, so in my macro I have named the row with the
total TOT_HOURS (=a and whatever the last row is)

In column B, on each row, I perform the calc b1/tot_hours, etc., to get the
percent to total.

How could I make tot_hours relational, that is, when I copy the formula to
column d, have tot_hours refer to column c instead of column a?

Just copying the formulas doesn't work.
 
define the range with relative columns, e.g.

=A$1:A$100

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking formula that SUM values with specific value in neighboring colum 2
calculate total hours based on dates 5
Importing sotck quotes 5
Find 2 values & return row number 1
Looking formula that gives total of remaining months 6
Excel Sumproduct 0
Excel Subtracting multiple columns from another column 3
"Contains" Formula 3

Back
Top