-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
r12
-
S
Range Error in VBA Code
Sub Deploy() Dim i, x, y, z As Long Dim R1, R12 As Range x = Cells(Rows.Count, "A").End(xlUp).Row For i = 9 To x R1 = Range("G" & i & ":J" & i) R12 = Range("K" & i & ":M" & i) y = Application.WorksheetFunction.Average(R1) z = Application.WorksheetFunction.Average(R12) Cells(i, "O") =...- srlakra
- Thread
- dim error error in range r12 range
- Replies: 4
- Forum: Excel Questions
-
P
time calculation 24 hour
hello! i have a sheet for recording trips, yes the same sheet i have been playing with for 17 years. P12 (formatted as text) is time (1109) Q12 (formatted as text) is time (1207) R12 (formatted as 13:30) is where i input the elapsed time. (0:58) S12 (formatted as number 0.00 )has a formula...- pile-it Mark
- Thread
- formatted p12 r12 text time
- Replies: 5
- Forum: Excel Questions
-
D
Sumifs counting r21 and r12 as the same??
=SUMIFS('[ABQCSR_TEMPLATE.xlsm]TABLE (4)'!$B:$B,'[ABQCSR_TEMPLATE.xlsm]TABLE (4)'!$A:$A,$C15) This is only supposed to find R12 IN THE C15 cell and look for it in TABLE (4)'!$A:$A. Then it adds up what sin the B column. Unfortunaly it adds the R21 & the R12 mixed up and adds them both.- Dark0Prince
- Thread
- adds counting r12 r21 table
- Replies: 1
- Forum: Excel Questions
