keeping a "floating cell"'s value

J

joflo65

HI,
I have a log that lists jobs--their start and complete times. I want a
total # of jobs started and completed. Not all jobs listed , start, and not
all jobs listed, complete. That is no problem, i use the counta().

My problem comes in where the # of jobs listed can vary, so the cell that
contains the "total" floats its row designation (it can be row 377 one day
and 380 the next). That total is linked to another worksheet cell where it is
totalled for the month. I keep having to go through and change the cell row
number on both the original worksheet and the destination worksheet to keep
the link working properly.

I know its ounds confusing but i need the metrics for productivity sake.
Please help....
 

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

Match and Sum? 2
IF function - need FALSE to return a blank cell, not 0 1
Vlookup maybe??? 4
Excel Changing chart label colors based on a value in a cell 0
calculating a value if adjacent cell has value 3
How do I create a graph from a worksheet? 2
Sum of different value in different worksheet & cell number 2
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0

Top