Absolute column but reference current row
Closed
Driving me crazy
-
Feb 6, 2012 at 03:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2012 at 09:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2012 at 09:36 AM
Related:
- Absolute column but reference current row
- Saints row 2 cheats - Guide
- Fire current casino - Download - Online gaming and betting
- How to delete a row in a table in word - Guide
- Display two columns in data validation list but return only one - Guide
- Saints row free download - Download - Action and adventure
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 7, 2012 at 10:23 AM
Feb 7, 2012 at 10:23 AM
Hi Driving me crazy,
Only cell references will change when autofilled.
When you place double quotes around a cell reference it becomes a value.
Besides that I don't understand what you are trying to do.
Your statement will only be true when formula is placed in cell T2, but then T2 doesn't have a value. So T2+U2 and U2 will have the same result.
I'm probably missing something, please fill me in.
Best regards,
Trowa
Only cell references will change when autofilled.
When you place double quotes around a cell reference it becomes a value.
Besides that I don't understand what you are trying to do.
Your statement will only be true when formula is placed in cell T2, but then T2 doesn't have a value. So T2+U2 and U2 will have the same result.
I'm probably missing something, please fill me in.
Best regards,
Trowa
Feb 7, 2012 at 11:09 AM
the formula is placed in cell U2, I want it to Autofill down (U3, U4....) as you stated T2 doesnt start out with any thing in it. Please see below
T U
Time Spent Total Time
1:00 1:00:00
0:00:00
0:00:00
0:00:00
0:00:00
When you enter a time in column T like 1:00 (1 hour) it keeps a running total in column U.
This formula does that for me
=IF(CELL("address")="$T$2",T2+U2,U2)
But it wont allow me to auto fill down.
If i remove the double quotes it does not work.
if i remove the second dollar sign it does not work
The autofill looks like this
=IF(CELL("address")="$T$2",T3+U3,U3)
where everything changes except the $T$2 - which needs to change to $T$3
I need to autofill for about 200 rows if i want the formula to work i can manually enter each formula for each row but i also have a macro that takes all completed rows and moves to another sheet. this causes the row numbers to change which if it autofilled would be ok, but since i have to manually enter the formula for each row, when the completed ones are removed it does not change the $T$2 part of the formula.
I hope i explained that in a way you could understand what i am trying to do
Feb 9, 2012 at 09:36 AM
I'm still trying to figure out what you want with the formula you are using.
=IF(CELL("address")="$T$2",T2+U2,U2) placed in U2.
CELL("address") will be $U$2.
$U$2=$T$2 will always be false.
Therefore result will always be U2.
You said:
When you enter a time in column T like 1:00 (1 hour) it keeps a running total in column U.
What I understand from that is the following.
Column(T) Column(U)
1:00 1:00
3:00 4:00
2:00 6:00
Coulmn(T) is entered, Column(U) is calculated.
Formula U2: =T2
Formula U3: =SUM($T$2:T3)
Drag this last formula down.
Are we on the same page?
Best regards,
Trowa