Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Firstly, please ask your question in the body of the message rather than
just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Hi David, thank you for replying I have been trying to figure this formula
out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0)
-- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Hi David,
I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
If you have v8 in A1 and v8 in B1, the formula will return v16. What do you
have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Would it help if I send you my worksheet? In a row, lets say row 5, I have
the name of the employee on col A5, v8 on col B5, s8 on C5 and v8 on D5... will it total to v16 (vacation hours) in a different col? and total s8 (sick hours) in a different column? "David Biddulph" wrote: If you have v8 in A1 and v8 in B1, the formula will return v16. What do you have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Hi David....
I do need your help, let me explain it to you better, sorry if I confused you, I can better illustrate it: col A col B col C Col D Col E Col F Col G Col H row 1 First Name Last Name v8 v8 sat sun v8 = V24 How do I get the formula to come up with the total vacation hours on Column H? Thanks for your help... Stacy "David Biddulph" wrote: If you have v8 in A1 and v8 in B1, the formula will return v16. What do you have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
So where you originally referred to column A and column B, you now want to
refer to columns C, D, and G? You will therefore need to change the formula to refer to those columns. -- David Biddulph "Stacy" wrote in message ... Hi David.... I do need your help, let me explain it to you better, sorry if I confused you, I can better illustrate it: col A col B col C Col D Col E Col F Col G Col H row 1 First Name Last Name v8 v8 sat sun v8 = V24 How do I get the formula to come up with the total vacation hours on Column H? Thanks for your help... Stacy "David Biddulph" wrote: If you have v8 in A1 and v8 in B1, the formula will return v16. What do you have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Im sorry to sound dumb but how can i get the sum of the columns again?
indicating v or s? "David Biddulph" wrote: So where you originally referred to column A and column B, you now want to refer to columns C, D, and G? You will therefore need to change the formula to refer to those columns. -- David Biddulph "Stacy" wrote in message ... Hi David.... I do need your help, let me explain it to you better, sorry if I confused you, I can better illustrate it: col A col B col C Col D Col E Col F Col G Col H row 1 First Name Last Name v8 v8 sat sun v8 = V24 How do I get the formula to come up with the total vacation hours on Column H? Thanks for your help... Stacy "David Biddulph" wrote: If you have v8 in A1 and v8 in B1, the formula will return v16. What do you have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get sum of v8(col a) and v8(col b) = v16(col c)
Try this array formual** :
Assumes that every cell that contains a "V" is *always* followed by a number. ="v"&SUM(IF(LEFT(C2:G2)="V",--MID(C2:G2,2,5))) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Stacy" wrote in message ... Im sorry to sound dumb but how can i get the sum of the columns again? indicating v or s? "David Biddulph" wrote: So where you originally referred to column A and column B, you now want to refer to columns C, D, and G? You will therefore need to change the formula to refer to those columns. -- David Biddulph "Stacy" wrote in message ... Hi David.... I do need your help, let me explain it to you better, sorry if I confused you, I can better illustrate it: col A col B col C Col D Col E Col F Col G Col H row 1 First Name Last Name v8 v8 sat sun v8 = V24 How do I get the formula to come up with the total vacation hours on Column H? Thanks for your help... Stacy "David Biddulph" wrote: If you have v8 in A1 and v8 in B1, the formula will return v16. What do you have in A1 and in B1? -- David Biddulph "Stacy" wrote in message ... Hi David, I tried the formula you gave me but it doesnt sum up the number of hours.... it only shows v0.... Thank you for replying Stacy "David Biddulph" wrote: ="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0) -- David Biddulph "Stacy" wrote in message ... Hi David, thank you for replying I have been trying to figure this formula out for days now... I am creating a worksheet for sick and vacation leaves.... v8 will be keyed in a column if the person is in vacation leave or s8 for sick leave (8 for 8hours) and I need to total how many vacation hours did the person take in one column hence, v8 + v8 = v16. And more importantly I need to only count the v's and s's to sum up.... I am sorry if i dont make myself clear... Stacy "David Biddulph" wrote: Firstly, please ask your question in the body of the message rather than just in the subject line. Secondly, you'll need to explain what you mean by v8(col a), v8(col b), and v16(col c) -- David Biddulph "Stacy" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|