software

I'm creating a timesheet for technicians in my service department. I have a
team-based system where technicians split the total hours their team does by
the number of techncians on the team, which is 4 per team. It currently
takes the hours in a top cell and automatically divides the hours into the
individual
technicians rows below (e.g., team turns 40 hours in a day, each technician
gets 10). Is there any way to exclude a cell if it contains a non-numeric
value (e.g., quot;VACATIONquot; or quot;SICKquot;), and recalculate by the number of open
cells left?

try this array formula
=AVERAGE(IF(ISNUMBER(L3:L14),L3:L14))

--
Don Guillett
SalesAid Software

quot;Service Managerquot; lt;Service gt; wrote in
message ...
gt; I'm creating a timesheet for technicians in my service department. I have
gt; a
gt; team-based system where technicians split the total hours their team does
gt; by
gt; the number of techncians on the team, which is 4 per team. It currently
gt; takes the hours in a top cell and automatically divides the hours into the
gt; individual
gt; technicians rows below (e.g., team turns 40 hours in a day, each
gt; technician
gt; gets 10). Is there any way to exclude a cell if it contains a non-numeric
gt; value (e.g., quot;VACATIONquot; or quot;SICKquot;), and recalculate by the number of open
gt; cells left?
I think what you gave me was the opposite of what I was asking (though I
appreciate the response). My spreadsheet colum for a sample team on a sample
day looks like this:

Tech Team A Monday
40
Tech#1 13.3
Tech #2 13.3
Tech #3 VACATION
Tech #4 13.3

Where 40 is the number of hours the team produced that day. The formula is
now set for each tech as the total colum divided by 4. I have to manually
change it to three, two, etc. when one or more members of each team are off.
What I want the spreadsheet to do is see a non-numeric value (in this case
VACATION) in the cell next to tech #3 when I type it in over top of the
formula, an dthen recalculate Techs #1, #2, and #4 accordingly. Is this
possible?

quot;Don Guillettquot; wrote:

gt; try this array formula
gt; =AVERAGE(IF(ISNUMBER(L3:L14),L3:L14))
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Service Managerquot; lt;Service gt; wrote in
gt; message ...
gt; gt; I'm creating a timesheet for technicians in my service department. I have
gt; gt; a
gt; gt; team-based system where technicians split the total hours their team does
gt; gt; by
gt; gt; the number of techncians on the team, which is 4 per team. It currently
gt; gt; takes the hours in a top cell and automatically divides the hours into the
gt; gt; individual
gt; gt; technicians rows below (e.g., team turns 40 hours in a day, each
gt; gt; technician
gt; gt; gets 10). Is there any way to exclude a cell if it contains a non-numeric
gt; gt; value (e.g., quot;VACATIONquot; or quot;SICKquot;), and recalculate by the number of open
gt; gt; cells left?
gt;
gt;
gt;