Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Values
I'm tryng to build a spreadsheet to track employee vacations. How do I
sum 8 hours if a cell has a "V" entered and 4 hours if a cell has an "X" entered? |
#2
|
|||
|
|||
Assuming you're using column A, and each row is either the number of hours
worked, or a V or a X, then use a helper column, B, and insert this in B1 and copy down.......change the A1's to A2's if you have a header in Row 1, and put this in B2. =IF(A1="V",8,IF(A1="X",4,A1)) Vaya con Dios, Chuck, CABGx3 "Brando" wrote in message oups.com... I'm tryng to build a spreadsheet to track employee vacations. How do I sum 8 hours if a cell has a "V" entered and 4 hours if a cell has an "X" entered? |
#3
|
|||
|
|||
Thanks!
But what I have is a workbook with 12 sheets with the months and 1 sheet with statistics. I have 30 employees listed down Column A and the days of the month across the row. The stat sheet sums the number of days taken by an employee. I want to enter a V to show he/she is taking a full day of vacation or an X to indicate a 1/2 day. This will allow employees to see what days are available. The stat sheet allows me to track how much time each employee has scheduled and taken. |
#4
|
|||
|
|||
If you want to add the numbers in a single row, including 8 for V and 4 for
X, then maybe this, adjusted for your row length might do it for you....... =SUM(A1:Z1)+(COUNTIF(A1:Z1,"V")*8)+(COUNTIF(A1:Z1, "X")*4) Vaya con Dios, Chuck, CABGx3 "Brando" wrote in message oups.com... Thanks! But what I have is a workbook with 12 sheets with the months and 1 sheet with statistics. I have 30 employees listed down Column A and the days of the month across the row. The stat sheet sums the number of days taken by an employee. I want to enter a V to show he/she is taking a full day of vacation or an X to indicate a 1/2 day. This will allow employees to see what days are available. The stat sheet allows me to track how much time each employee has scheduled and taken. |
#6
|
|||
|
|||
You're more than welcome...........thanks for the feedback...........
Vaya con Dios, Chuck, CABGx3 "Brando" wrote in message ups.com... That did it for me! Thanks so much for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many different text values in an array. | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
text and values combined in one cel | Excel Discussion (Misc queries) |