Excel Formula Help In Timesheet 2

[esb6]

In a Excel company timesheet, salary employees get an "X" for daily work or a "V" for vacation. What formula can be used to convert X to equal 8 so it can be summed for weekly and bi-weekly totals?. Right now the supurvisor manually enters the total for salary employees and then has a sum formula to count the hourly employees hours.

 

[SkipVought]

Hi,

Insert a ROW or COLUMN, as the case may be with the formula referencing the ROW or COLUMN containing the Xs...
[tt]
=if(cellref="X",8,0)
[/tt]
Then hide that ROW or COLUMN.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[AnotherHiggins]

You could just count how many Xs there are then multiply that by 8.

[tab]=CountIf(A2:A8,"X")*8


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[esb6]

Thanks Skip. Worked great! I haven't had an excel class since 2000 so I am rusty.

 

[SkipVought]

John's solution is a good one too.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[esb6]

Thanks, anotherhiggins, that works great also!

 

[AnotherHiggins]

glad we could help!



[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.