Dragging a formula
 

I have the formula below that T. Valko helped me with and it drags down the
columns fine but when I drag across it doesnt compute what I need. Perhaps I
need absolue reference symbol in front of the letter instead of the number in
each cell? Not sure really, I just know it makes me dizzy...Thanks for any
help!
-CRM

=ROUND((MAX(0,MIN(D$10*(D$10<""),B55)-MAX(C$10,A55))+MAX(0,MIN(F$10*(F$10<""),B55)-MAX(E$10,A55))+MAX(0,MIN(H$10*(H$10<""),B55)-MAX(G$10,A55))+MAX(0,MIN(J$10*(J$10<""),B55)-MAX(I$10,A55)))/60*1440,2)
--
-CRM

Dragging a formula
 

When you drag that across, the cell references like D$10, B55, C$10,
A55 etc will change like this:

E$10, C55, D$10, B55 in the next column.

However, if you put the $ symbol in front of the letters, then they
won't change.

But, there might be some of these that you DO want to change as you
move across the sheet, and as you haven't given us any explanation of
what this formula is for or how your data is laid out then only you
can decide which column references needs to be fixed by the $ symbol
and which should be allowed to change.

Perhaps Biff will pick this up again...

Pete

On Jan 13, 2:23*pm, saltnsnails
wrote:
I have the formula below that T. Valko helped me with and it drags down the
columns fine but when I drag across it doesnt compute what I need. *Perhaps I
need absolue reference symbol in front of the letter instead of the number in
each cell? *Not sure really, I just know it makes me dizzy...Thanks for any
help!
-CRM

=ROUND((MAX(0,MIN(D$10*(D$10<""),B55)-MAX(C$10,A55))+MAX(0,MIN(F$10*(F$10<*""),B55)-MAX(E$10,A55))+MAX(0,MIN(H$10*(H$10<""),B55)-MAX(G$10,A55))+MAX(*0,MIN(J$10*(J$10<""),B55)-MAX(I$10,A55)))/60*1440,2)
--
-CRM

Dragging a formula
 

If you put the dollar symbol in front of the letter then it won't change as
you drag across. If you put a dollar in front of the number it won't change
as you drag down.
--
David Biddulph

"saltnsnails" wrote in message
...
I have the formula below that T. Valko helped me with and it drags down the
columns fine but when I drag across it doesnt compute what I need.
Perhaps I
need absolue reference symbol in front of the letter instead of the number
in
each cell? Not sure really, I just know it makes me dizzy...Thanks for
any
help!
-CRM

=ROUND((MAX(0,MIN(D$10*(D$10<""),B55)-MAX(C$10,A55))+MAX(0,MIN(F$10*(F$10<""),B55)-MAX(E$10,A55))+MAX(0,MIN(H$10*(H$10<""),B55)-MAX(G$10,A55))+MAX(0,MIN(J$10*(J$10<""),B55)-MAX(I$10,A55)))/60*1440,2)
--
-CRM